Sharing an Access database could be done between two or more templates, such as an invoice template and a packing list template, or between two or more computers. This feature is supported in the "Net" and "Enterprise" edition. Refer to Differences between editions for more information.
By sharing database two or more users could work on same database file.
NOTE: Each computer requires its own license key/registration code.
Sharing Access database file requires the computers connected on a LAN (locally area network). If you need to share data via the Internet, choose the "Enterprise" edition and migrate the Access database file to online SQL Server. See Online Invoicing Sample for a practical example.
This simple tutorial goes through the steps for sharing database(s) between two computers.
Let's say we have two computers. Computer LIVINGROOM running Windows 8 will host the shared database file, and another computer running Windows 7 will connect to the database hosted on LIVINGROOM. You can easily find similar options on Windows 10. These two computers are locally networked -- i.e. connected via a LAN.
Once the template successfully connects to the shared database, thefield on the worksheet will show the name of the database that is currently connected with.
Tip: If you see the error "An error occured while submitting data. Operation must use an updateable query.":