Create Standard MDB From Workgroup MDB?

[a6m1n0]

Hi,

How do I remove the Workgroup features of an MDB but retain the scripts and data? I am looking to migrate the MDB to a web application for my company.

Thanks in advance for any insight.

 

[a6m1n0]

For the next person that has the same question:

1. Login with the Admin user
2. Remove the Admin user form all groups except the Admins group
3. Clear the Admin user password
4. Give the Admin user Full permissions on all objects.

The MDB should now be free of the workgroup login.

TIP: Microsoft calls this procedure "de-securing the database." Search google or technet if the procedure somehow doesn't work for you.

-a6m1n0

A*(256)^3+B*(256)^2+C*(256)^1+D

 

[JoeAtWork]

Pointing to an MDW where the Admin never had a password in the first place probably would have worked to.

 

[PHV]

Joe, a properly secured DB gives NO permission to the admin user ...

 

[jsteph]

a6m1n0,
I'm surprised MS gives that as a proper procedure because as phv said, if it were secured you couldn't log on as admin.

You'd need the .mdw file under which the db was secured and you'd need to log in as the dbowner.

At that point you could grant admin all pemrissions, and the best case to totally de-scure would be to create a new mdb under the standard system.mdw logged in as admin and import all objects so that the dbowner is now admin.
--Jim

 

[JoeAtWork]

Joe, a properly secured DB gives NO permission to the admin user ...

Agreed, but from the context of the post I am guessing the database never was properly secured, i.e. the default Admin account continued to have full rights to all objects.

It all depends on whether step 4 needed to be carried out.

 

[a6m1n0]

To elaborate, I just followed the directions from section 34. How can I "de-secure" a database? of the following document located here.

-a6m1n0

127*(256)^3+0*(256)^2+0*(256)^1+1