access 97 file

A

Antz

we have a file multiple users work of
can more than one user make changes to the file at the same time?
No, right - they have to wait till one finishes and saves it correct?

thanks
 
R

Rick Brandt

Antz said:
we have a file multiple users work of
can more than one user make changes to the file at the same time?
No, right - they have to wait till one finishes and saves it correct?

thanks

Multiple users can edit at the same time but not the same record (or in
Access 97 no record in the same data page of storage). For multiple users
though it is *highly* recommended that the app be split into a shared data
file and individual front end files stored on each user's local drive. If
you just toss a monolithic file onto a network share and have multiple
people using it you greatly increase the chance of the file becoming
corrupted.
 
A

Antz

thanks so much !!!

antz

Rick Brandt said:
Multiple users can edit at the same time but not the same record (or in
Access 97 no record in the same data page of storage). For multiple users
though it is *highly* recommended that the app be split into a shared data
file and individual front end files stored on each user's local drive. If
you just toss a monolithic file onto a network share and have multiple
people using it you greatly increase the chance of the file becoming
corrupted.
 
A

Antz

what about a
But in the sub-form, only one user can use it at a time?
access 2000?

thanks!!
 
Top