CODEWITHSUNDEEP
ms-access
jpl458
jpl458

Reputation: 615

OPening multiple copies of ACCESS app

Environment: Windows 7, ACCESS 10, SQL Server. Have an ACCESS app that resides in a single location on a server. I want to allow three users to use this app at the same time. The app is read only to SQL Server, but currently only one user can use the app at a time. If one is open the others will not open till the open one is closed. Looked all over the web, and went through options in ACCESS. How do I set it up so all can use it at the same time.

Thanks

jpl

Upvotes: 0

Views: 44

Answers (1)

Gustav
Gustav

Reputation: 55906

The easy and recommended workaround is to distribute a copy of the Access file to each workstation so each user has an independent copy.

Upvotes: 1

Related Questions