LOSE MDB DEPENDENCY

Hi All,
what is the procedure/steps to migrate an MS Access mdb front-end (BE is SQL Server) off mdw control?

I need to create a new accdb from the old mdb, and also lose all influence/control of the mdw

The bigger question is: is it possible to create a new accdb and import all objects from the mdb, without concerning oneself with the mdw at all?

thank you
LVL 7
COACHMAN99Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I assume by MDW you mean User Level Security (?), which was deprecated in A2007.
If so, I would suggest using the ULS Tool/Work Group Administrator (which itself is still available in at least A2007) and removing/undoing ULS in the MDB. In fact, you could probably do this within the A2007 (or greater) on the MDB.  So, at least A2007 (not sure about >=A2010) still supports ULS .. IF ... the file format is MDB.
In fact I suspect ... if you have a copy of the Work Group Administrator (MDW) ... it might run in >= A2010.  Worth a try.

Good luck
0
COACHMAN99Author Commented:
thanks Joe
so there is no easy way of importing the objects without using the mdw and tools?
where does one find the ULS Tool/Work Group Administrator? and would I have to open the original mdb using A2007, and then try and remove all mdw influence?
cheers
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I would search your C drive for *.MDW ...
Do you still have a version of Access < A2007 ?

"so there is no easy way of importing the objects without using the mdw and tools?"
Not that I am aware of.

Also, you should ... still be able to find KBs on how to remove ULS ... on the Microsoft site and/or Google.
Overall this exercise should ... be relatively simple.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I just did a search on both my A2013 and A2016 systems ... and both have system.mdw still ... but that is not the WkGrp mdw.
0
COACHMAN99Author Commented:
only have A2007 and later.
is the workgroup administrator built into the A2007 designer, or a separate utility? (called what?)
what is system.mdw?

I can do some research tomorrow.
thanks for your help and input
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
As I recall the WGA tool is NOT available off of the menu .. but now 100% sure.
system.mdw is not the tool.  But it's the file that handles ULS ... and contains any custom configurations of ULS beyond the default, not ULS enabled MDB.

OK .. this looks promising:

https://www.thegrideon.com/mdb-mdw-in-new-msaccess.html

as does this:

http://www.addintools.com/documents/access/where-is-workgroup-manager.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
COACHMAN99Author Commented:
excellent thanks. i'll run with it.
cheers and goodnight :-)
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
cool.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Couple things to add:

1. As long as you have Access to the DB, you can convert it.  Open the DB in A2007 and using the /wrkgrp switch on the command line.   If you don't have access to the DB, you'll need a workgroup recovery utility or use a service.

2. With A2007 and up, ULS is stripped out., not removed.  What the conversion does is remove all ACL's (Access Control Lists) from the DB leaving the default security setup.   That's why you find system.mdw even with ACE.   They are workgroup files and are just like the normal default workgroup files you got with previous versions.

3. The work group admin app is now built-in and available through the ribbon.

Jim.
1
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.