Question cant open shared access file

[ghodges]

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?

 

[boblarson]

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.

 

[ghodges]

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

 

[boblarson]

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