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?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
COACHMAN99Author Commented:
excellent thanks. i'll run with it.
cheers and goodnight :-)
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.