Access 2002 error "You do not have the necessary permissions"

[Bruce C]

I am administering a multi-user, unsecured Access 2000
(Win 2K OS) database with a SQL back end. User's machine
has been upgraded to Access 2002 (still Win 2K OS).
Permissions on the folder have been fully opened;
permissions on the database file have also been fully
opened. The user's logon has been registered with SQL and
the user added to a group with full rights to all objects.
Still, the db will not open ... it delivers a "You do not
have the necessary permissions to use the <database path
and name> object. Have your system administrator (etc.)...
It won't even allow opening by me!

Anyone seen this before or know what is going on? What's
the fix? Thanks so much for any help.

Bruce

 

[Scott McDaniel]

Is the <database path and name> the name of the Access front end or the SQL
server back end? I'm assuming it's the Access front end ...

All Access databases are secured, regardless of whether you implemented
security or not. The error you're receiving basically means that the db
cannot find the proper workgroup needed to open it. The permissions for your
folders, SQL Server, etc etc are not causing the problems.

Is this database running properly on another machine? If so, do you launch
it from a desktop shortcut? If you do, then go to that machine and determine
where the .mdw file is located (right click on the shortcut, select
properties). Copy that string, go back to the offending computer, make a new
desktop icon, and paste the copied string in the appropriate place. Try
opening the database using that shortcut.

Note that this will work if the .mdw file is accessed over the network (if,
for example, the .mdw file is housed on a server). If the .mdw file is
housed on each individual machine (and it shouldn't be), then you'll have to
copy/paste that file on the offending machine.