Question cant open shared access file

ghodges

Registered User.
Local time
Tomorrow, 03:10
Joined
Dec 1, 2009
Messages
13
Hello,
I am having trouble opening a shared database (access2000) in a 6 machine network

All other machines can open it, and share it properly...except me

I cant open it at all unless i have exclusive access to the database

once i have the file open on my computer ,then everybody can get to use it whilst i have the file open.

the problem comes when i exit out and want to get back in, i need to get everybody else out, so i can get in, then they can get back in again

I do not receive any errors at all when trying to get into the database. When i click the shortcut, to open the file the machine waits about 3-4 sec and then just ignores my request
no messages,no warnings, what so ever

Is this a problem in access or the machine that i am using
The operating system i am using is xp with office 2003
many of the other machines are using exactly the same

does anybody have any idea on which direction i should take to resolve this?
 
does anybody have any idea on which direction i should take to resolve this?
Yes -

Split the database into a frontend/backend and put a COPY of the frontend on EACH user's machine. That is how you should be running a multiple user (and I'd say even a single user) database. See here for more about that.
 
Thanks Bob for your quick reply

I have split the database and yes the problem has gone away.

Thanks for your idea, I had considerered it earlier but guess i was sort of interestred in why.

I guess the reason does not matter as long as the problem has gone

Thanks again
Geoff
 
If you read the article I posted the link to, it should explain very well all about it.
 

Users who are viewing this thread

Back
Top Bottom