Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database not worked in a network.

Status
Not open for further replies.

miho1

Technical User
Oct 22, 2002
78
BG
Hi All

I work with database Access2000. All is good.
But when in a network, the first user communicates normally
But the second can not contact database.
Database protected passwort.
That it is necessary to make that the database worked in a network?

Miho
 
Hi

Are you sure it is a password problem and not a USer Network permissions problem?, all users who use the database must have full permissions in the folder where the database is located

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
 
Ken Thanks for the answer.

It not password problem.
When user one is not present a problem.
But when one user has already contacted database
And another wants to communicate is shown
The message " You can't open vbd.mdb because another user has the database open "

Miho
 
miho1

Sound like the first person in is opening the database in exclusive mode. Check Access on the various machines to insure they are set to shared use. Tools/Options, Select Advanced tab and make sure the default open mode is shared.

Mark
 
Hi

I agree with baderms, check for anyone opening databse exclusive if still problem persists check ou my comment from first post "a User Network permissions problem?, all users who use the database must have full permissions in the folder where the database is located "

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top