Access to a database form for more users at the same time

[Mirjam]

Hi, I created a database where everybody should insert his holiday plans and absence of business. the Database is linked and opens automatically the form when you click on the link on the pdf. But know it is not possible anymore that more than one person opens the file to insert the data. The mistake is: Could not lock file!
What do I have to do that more people can use the database at the same time (not only read-only) Thank you for the help

 

[Pat Hartman]

The two most common causes of this are:
1. Insufficient network permissions - users of the database need both create and delete rights to the database's directory in order for Jet to create its lock file (extension .ldb)when the first user opens the database and delete it when the last user closes the database. If Jet is unable to create the lock file, it will open the database as read-only for users subsequent to the first.
2. Jet uses this lock file to track what people are doing in the database. If the first user to open the database modifies any objects such as queries or forms, all subsequent users will be read-only.

Not related to your sharing issue but best practice is to split the database into a front end that contains all objects such as forms and reports and a back end that contains only tables. The front end database links to the tables in the back end. In this scenerio, the front end is copied to the c: drive of each user so that all users have a private copy of the front end. All these private copies of the fe link to the shared be on the network share.