Allowing multiple users the ability to work in database simultaneo

[Ryan]

What do I need to do to enable this. Sometimes when I am in the database
other users are not allowed to open it. Says locked by adminitrator or
something to that effect--even when Im not in edit mode.

Thanks.


baseball

 

[Douglas J. Steele]

All applications should be split into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relations).

Only the back-end should be on the server. Each user should have his/her own
copy of the front-end, ideally on his/her hard drive.

 

[Ryan]

how would I set this up with an already established database?

 

[Douglas J. Steele]

Check what Tony Toews has at
http://www.granite.ab.ca/access/splitapp/index.htm or what Albert Kallal has
at http://members.shaw.ca/AlbertKallal/Articles/split/index.htm