Users in Access 97

S

Samrasr

Hi,

I have designed a database program which is used by users on different
machines.
For example i will input information from my computer and at the same time
others will also open my database from their own machines at the sme time.

Will this affect the information or the database in any way?

Grateful for your info
 
D

Douglas J. Steele

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

Each user should have his or her own copy of the front-end on their hard
drive. Only the back-end should be accessed over the LAN.

Tony Toews has information about database splitting at
http://www.granite.ab.ca/access/splitapp/index.htm
 
Top