MS Access Shared Access Error

Hi
I have a secured Access 2000 database that does not allow more than
one user to access it at a time.
The error message that displays when the second user tries to log on
is:
Could not use 'Admin';File already in use.

I have set the database to open for shared access.
I have tried repairing the database.
The problem persists.

Please help.
Looking forward.
OwenTech
owentechAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

shanesuebsahakarnCommented:
Make sure that your users have read/write/execute/create/delete permissions in the folder where the database is stored (or where the back end database is stored) - otherwise, Access cannot create an ldb file and will open the db in exclusive mode, preventing other users from logging in.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TextReportCommented:
Also if you have and MDW or MDE or MDB file of the same name then they will all use the same LDB file, dont call them all the same in the same location.

Ensure the user(s) are not opening exclusive due to a command line parameter.

Personally I always put a copy of the front end onto the local drive and get the user to open that exclusively as this helps in performance by reducing network traffic.

Cheers, Andrew
0
nexusnationCommented:
Hi owentech,
This question has been abandoned and needs to be finalized (100 days since last comment).

   You can accept an answer, split the points, or get a refund. Go to
   http://www.cityofangels.com/Experts/Closing.htm for information and options.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

nexusnation
EE Cleanup Volunteer for Microsoft Access
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

1WilliamCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept question, split points to shanesuebsahakarn  and  TextReport
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

1William
EE Cleanup Volunteer
0
TAUBEBECKERCommented:
We got the following response from Microsoft on this problem:  
Message "File already in use" When Running Access 2000 from a Network -  (Office running from the network)  
 ---------------------------------------------------------
                If you are running Access 2000 from the network, you might receive the following message when you open an Access database: Could not use 'Admin'; file already in use.  This message occurs when a user who has Write permissions to the network share opens an Access database; subsequent users who have only Read permissions to that share
receive the message when they attempt to open an Access     database.  
                After you have run the administrative installation of Office 2000 or Access 2000, you can prevent this message by setting the effective share-level permissions to Read
permissions for all users who will run Access 2000 from
the network server. If you are an administrator, you
might want to create a separate share to the same folder,
and give any administrators Full Control permissions so
that they can maintain the files in this folder. However,
all users should install Office 2000 or Access 2000 from
the share with Read permissions.  
0
aptonCommented:
I know this topic has been closed, but I found an alternate answer. This solution applies if you are running Access 2000 databases in a Citrix environment and getting the "Could not use 'Admin', file already in use." error.

With the use of Filemon, I was able to track the error to the system.mdw file located in LocalDrive:\Program Files\Common Files\System. Just giving Users Modify rights to the file is not enough, the group needed modify rights to the folder. Once that was done the error disappeared and my clients were able to work happily again.

Hope this can make someone's day.

-brad
0
aptonCommented:
I know this topic has been closed, but I found an alternate answer. This solution applies if you are running Access 2000 databases in a Citrix environment and getting the "Could not use 'Admin', file already in use." error.

With the use of Filemon, I was able to track the error to the system.mdw file located in LocalDrive:\Program Files\Common Files\System. Just giving Users Modify rights to the file is not enough, the group needed modify rights to the folder. Once that was done the error disappeared and my clients were able to work happily again.

Hope this can make someone's day.

-brad
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.