Software

Ask something
Discussion Locked

Access problems to MS Access 2000

0 helpful
3 replies

by jamyot

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Ok so one of my users tries to access a database, on a network drive using access 2000 and gets the error "could not use admin File already in use* When I log onto the user's machine and try to access it, I have no problems opening it up. Am I missing something here?

3 replies

by donq

Yep - when you log on your User ID (as in CurrentUser()) has access to the Access database, and when anyone who hasn't been granted data access to the .mdb file tries to log on they get an error because they aren't a member of the Admin User AccountAND they aren's authorized to add themselves.

If you can get in you must add their User ID as well.

by jamyot

I had to logon as admin, go to tools, security, user and group permissions. From there I added users. Now its ticky boo. Thanks

This discussion is closed to new replies.