Scott Price:
Thank you for your response. That is exactly what i have designed! I have a front end and a backend. Then if the front end is stored on say 5 user machines then when the user goes to open the front end .mdb will he/she have to go:
1. Tools, Database Utilities, Linked Table Manager
2. Select all etc...
each time the want to use the application? Or is that a one time deal?
Thank you!
-Dev1
Quote:
Originally Posted by Scott Price
Your question is far to general to give a specific answer to!
Yes, Access does record locking. It uses a temporary .ldb file to keep track of who is updating which record and keeps other users from updating the same record.
As a general overview, you split the database into two files: A 'front-end' .mdb file that contains the code/queries/report/forms and a 'back-end' .mde file that contains the tables. The .mde file resides on your server, each user gets a copy of the .mdb file. Access has wizards to help you with each step of this process, from the splitting to the linking.
Regards,
Scott
