Networked database

[Guest]

I have an access 2003 database on a local network, but I am having trouble
with it not allowing multiple users. When one person is editing a record it
prevents others from entering the database. This is a problem since some
people tend to leave an edited record open for a long time.

Any ideas?

 

[Guest]

split the database - but the Front End on each user's desktop...then you
should have no problem...

 

[Douglas J. Steele]

Does everyone have full permissions (Read, Write, eXecute, Delete) on the
folder where the MDB exists? (Of course, NTC's suggestion of splitting the
application into a front-end, containing the queries, forms, reports, macros
and modules, and a back-end, containing only the tables and relationships,
which each user having his/her own copy of the front-end on his/her hard
drive, is a definite must)

 

[Scott]

Douglas,

It seems the folder for MDB must be given the full permission. If not, how
can they open the database by generating the ldb file on the same folder.
Did I misunderstand your question?

Thanks,

Scott

 

[Douglas J. Steele]

You're correct that the ldb file wouldn't be generated if they didn't have
Write permission on the folder. However, it's possible to use the mdb
without those permissions (although I would expect to get a "read-only"
mesage in that case).

 

[Guest]

I thank everyone for their responses. Splitting the database solved the
problem. I have used access extensively, but never on a server.