Hi All

Have upgraded to 2007 (have I done the right thing here?....) and I am trying to open the database in exclusive mode to allow me to apply a certificate/licence to the DB- however Access complains I do not have correct permissions. I cannot open Workgroup Administrator (which incidentally has to be done from a macro routine) because I am unable to save it (again, dont have permission).

There is no concept of Workgroup Administrator in 07 as the security features have been revised - but according to the help files DBs can still be opened in 07. What am I doing wrong? I have created a macro to RunCommand to open the Workgroup Administrator in an empty DB and selected the original MDW file. But if I try and import all the tables etc. from my original DB - errors saying do not have Design permission to import ......

The DB opens in the user mode every time without the login dialog box....

What a nightmare.... any help gratefully received please.

Thank you.

User level security is not available in the new ACCDB file structure within Access 2007. In order to use user level security with Access 2007, you need to keep the old MDB structure.

http://www.access-programmers.co.uk/forums/showthread.php?t=140375

Follow this thread, I had the same problem

David
Thanks - I had actually previously seen your posting and had already setup trusted areas for use with no problems!

Although I have created an ACCDB file (2007 file formaT) I still have the security permissions of 97 in the MDW file. I may do away with this though as all my security I have written and coded within the DB - so this is rather surplus to requirement now anyway!