use database in network.

vivou

Registered User.
Local time
Today, 17:36
Joined
Dec 15, 2002
Messages
16
here my question :
i build a little application database-oriented.

now i have a problem:

if the application will be on the network- on all people computers, so how it will be with the database?

how can i set the application as locked or something else to avoid 2 people to use it at the same time??

if 2 people open the appl. at the same time, all the indexes in the tables will be wrong, a real mess...

do someone know how to do that?
 
Split your mdb into a front-end mdb (non table objects) and a back-end (table objects). Place the BE on you shared file server, and a copy of the FE on each users PC. Store a copy of the FE on the file server which can be pushd to or downloaded via a batch file by each user.

This will get you started and will solve most, but not all, of the problems with conflicts. Rarely will two users create new records to the same table at exactly the same time, but it can happen. When it does, one will lose his table changes.

The solution to this problem is more than trivial. I suggest that you get a good Access database book and read up on the roblem. Litwin, et al's Access Developers Handbook is suggested. There's a multi-volume edition (VBA, Desktop and Enterprise) for each version of access. The enterprise edition explains to total solution to your posting.
 
You can set Default Record Locking under Tools-Advanced to Edited Record which will also help.

Autoeng
 

Users who are viewing this thread

Back
Top Bottom