File Locking

[eacollie]

I have two backend and two frontend databases. These were developed over a period of time and were not integrated for various reasons.

TableA (in backend database#1) is linked to both frontend databases.

When user#1 of frontend database#1 has a form open that is bound to tableA and user#2 of frontend database#2 has a form open that also uses tableA, will there be a problem in file locking? Should they be able to print a report, for example, that is bound to this same table?

Thank you

 

[Galaxiom]

By default Access bound forms use Optimistic Locking. This allows multiple users to even open the same record together. Before updating the record it checks if anything has changed by other users and issues a warning if so. Otherwise it quitely updates.

Note that all users should be running a separate copy of any front end. They should not share.

 

[eacollie]

Thank you Galaxiom. All users have the same frontend (#1 or #2) on their local computers. If a problem exists with two users (frontend #1 and frontend #2), and they have the same network permissions, do you have any suggestions as to what the problem may be?

 

[Galaxiom]

I assume there is a message when the fault happens. What exactly does it say and exactly when does it occur?

 

[eacollie]

The message that displays is "cannot use ___; file already in use." So it's a file locking problem. It happens as I mentioned in my first post.

 

[eacollie]

We've been told by the network administrator that the users who were not able to create a lock file on the network server did not have share permissions to this folder. Once this was corrected, all is well.

Thanks!