access 97 file

[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

 

[Rick Brandt]

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.

 

[Antz]

thanks so much !!!

antz

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.

 

[Antz]

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

thanks!!

 

[Rick Brandt]

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

thanks!!

That should not be the case. Do all users have full rights to the folder as
well as the file? Are you sure no one is accidentally opening it in exclusive
mode?