Workgroup Permissions

[David]

I have an Access 97 database with workgroup security. I may or may
not be able to remember the log in passwords. However, when I start
the database in Office 97 under W98 or Office 2003 under XP Pro, I get
the message that I do not have permissions on the switchboard or it
cannot load something. It never gives me the option to enter a user
name and password. Also, I cannot import into another blank DB. I
get the message that I do not have the permissions to do so. I have
looked everywhere and cannot find a solution. Any thoughts?

David

 

[Graham Mandeno]

Hi David

You must open the database using the workgroup file (.MDW) that was used to
secure it. Create yourself a shortcut with the following target line:

<path to msaccess.exe> <path to database> /wrkgrp:<path to workgroup file>

For example:

"C:\Program Files\Microsoft Office\Office\msaccess.exe"
"C:\My Documents\My Database.mdb"
/wrkgrp:"C:\My Documents\My Security.mdw"