splitting database for multiple users

[Guest]

Hi
I have a database which I want to be used by about 10 users, simulataneously
at times. I have split my database into front and backends. This created a
'LDB' linking file. I have installed the LDB and the front end MDB in a
seperate folder for each user on our network drive, and each of them has a
desktop shortcut to their own front end in their own directory of the network.

When they try to open the main form which runs off the 'TBL Scheme' access
tells them that it
'could not lock the table TBL Scheme beacuse it is in use by another user or
process.'

But no-one has the TBL Scheme open as no -one is using the backend, they
only have their own front end open.

This is driving me nuts please can anyone help!! It might be to do with
refreshing links but I am tired of trying to figure it myself and would
appreciate someone giving me the answer!!!!!

 

[Guest]

Sorry,
I think it might be to do with 'windows permissions' not being set to 'full
occontrol' so the users can't 'lock' the records. ???!?!?

 

[Douglas J. Steele]

No need to copy the LDB file. (In fact, you don't want to).

Access manages it itself: the first user into the MDB will cause the LDB to
be created, subsequent users will update that LDB, and the last user out
will cause the LDB file to be deleted.

Does each user have Change access (Read, Write, eXecute, Delete) to the
folder where the backend database is located?

 

[Guest]

Yes Doug they all have those permissions on the folder containing the back
end DB thanks

 

[Guest]

Someone please help!!!!! thanx