Admin/owner of the db is receiving permission message

[Guest]

I have a user that is the admin/owner of the db and is receiving the "you do
not have the necessary permissions, see the db admin" even though others are
able to access the db fine. Any suggestions where to look

 

[Joan Wild]

It sounds like you aren't using the correct mdw file. Create a desktop shortcut with the following in the target:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"

 

[Guest]

Hi Joan,

Thanks for this suggestion. Unfortunately it did not work as the db is in a
network folder, not local and other users with less permission authority are
able to access it just fine. Any other suggestions?

 

[Joan Wild]

Hi Joan,

Thanks for this suggestion. Unfortunately it did not work as the db is in a
network folder, not local and other users with less permission authority are
able to access it just fine. Any other suggestions?

You need to be clear on whether you are talking about Windows permissions or Access permissions.

Windows - all users need read/write/create permission on the folder where the mdb is located.
Access - you need to ensure that the users are opening the mdb while using the correct mdw file - is Access security in place on this mdb?

 

[Guest]

Hi Joan,

I am sorry that I did not make this clear that I am talking total about
Access security on a network located database. This is something that just
started happening for this user and she tells me that nothing has changed
other than the only other admin/creator is no longer with the company. The
..mdw is in the network folder, both users are listed, I have not verified
that the one that is able to access the db is really using the .mdw, as he
does not have a local copy on his PC.

The other user does not have a problem getting to the database, where the
security window prompting for name and password appear.

Could it have to do with the locking file?

Thanks,
Cliff

 

[Joan Wild]

Hi Joan,

I am sorry that I did not make this clear that I am talking total about
Access security on a network located database. This is something that just
started happening for this user and she tells me that nothing has changed
other than the only other admin/creator is no longer with the company.

Is it possible that the other admin was removed as a user from the mdw file? This username may have owned or had sole permission; if they were deleted then it could cause problems.

The
.mdw is in the network folder, both users are listed, I have not verified
that the one that is able to access the db is really using the .mdw, as he
does not have a local copy on his PC.

He doesn't need a local copy on his PC. You can specify the network location for the mdw file using either a mapped drive or the UNC pathname
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"

The other user does not have a problem getting to the database, where the
security window prompting for name and password appear.

How are they getting into the database? Via a desktop shortcut; direct opening in Windows Explorer??

Could it have to do with the locking file?

I don't think so, from your description. However, to make sure, get everyone out and ensure that no ldb file remains in the folder (just delete it if one exists).

You should also make sure that the mdw file on the server isn't named the same as the backend mdb.

Users need read/create permission on the folder where the mdb/mdw reside.