Hi ,

I need to remove the workgroup information file from my MDB file (i.e) removing security check from my project. Can any one help me in it?

Create an empty unsecure(!) database
Start up the secure database.
Export all objects to the unsecure database.
Close the database.
Do this for the frontend as well as the backend database.
Copy all startup settings and recreate all file specs in the new unsecure database.

Enjoy!

Create an empty unsecure(!) database
Start up the secure database.
Export all objects to the unsecure database.
Close the database.
Do this for the frontend as well as the backend database.
Copy all startup settings and recreate all file specs in the new unsecure database.

Enjoy!

To the best of my knowledge this process won't transfer the relationships though.
Do we have to recreate them or is any other automatic way?

To the best of my knowledge this process won't transfer the relationships though.
Do we have to recreate them or is any other automatic way?Not to my knowledge. You have to recreate them. Same goes for the import and export specifications you might have made.

If you find a way, please let me know!

Get the Security FAQ from the Microsoft KB (there may be a link somewhere on this forum) and follow the directions EXACTLY.

im sure you can import these things from the secured database

join the workgroup, then open your unsecured database, with that workgroup

you should have full privileges, as you are always in the usergroup, which for this dbs has full privilege

now you should be able to import the specs etc from the secured database

(without compromising your unsecured datbase)

try it that way

The FAQ gives definitive instructions. There is no need to guess.