Como posso permitir que vários usuários abram um banco de dados de acesso em um compartilhamento de rede?
Share a database by using a network folder
The simplest way to share a database is to put it on a shared network folder. Although this is the simplest method, it is also the most limited. Before you consider this method, all the following conditions should be met:
No more than a few people are expected to use the database at the same time.
No Memo fields are present in the database, or if they are, they will not be simultaneously updated by different users.
Users do not need to customize the design of the database.
Note This method is less secure than other methods of sharing a database, because each user has a full copy of the database file, increasing the risk of unauthorized access.
To share a database by using a network folder
If one is not already available, set up a shared network folder.
For help with this step, see the help system for the operating system of the computer that you want to use to share your database. If the shared folder is on a network server, you might need assistance from the network administrator.
Make sure that Access is set to open in shared mode on all of the users' computers. This is the default setting, but you should check to be sure — if a user opens the database in exclusive mode, it will interfere with others' use of the data. Perform the following procedure on each computer:
Start Access.
Click the Microsoft Office Button Office button image, and then click Access Options.
In the left pane of the Access Options dialog box, click Advanced.
In the right pane of the Access Options dialog box, in the Advanced section, under Default open mode, select Shared.
Click OK, and then exit Access.
Copy the database file to the shared folder. After you copy the file, make sure that the file attributes are set to allow read/write access to the database file. Users must have read/write access to use the database.
On each user's computer, create a shortcut to the database file.
When you enter the path to the database file in the Target property of the shortcut, use a UNC address instead of a mapped drive letter. For example, instead of F:\sample.accdb, use \computername\shared.accdb.
Note This step can also be performed by the users themselves.