Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Making Access Database Online

Copper Contributor

Hi all, 

I want my database to work like MS Excel where multiple users can view and edit the file simultaneously. Does anyone have any suggestions on how I can go about this? 

Thank you in advance.

1 Reply
Access is works with multiple users. To do so, the database is split with all tables stored on the local area network in a shared backend file. All other database objects (queries, forms, reports, macros, modules) are stored in a front end database which has the backend tables LINKED to it. Each user needs their own copy of the frontend database on their own workstation (not in the network).

So far so good...
However, your thread title mentions the database being ONLINE.
Access files do NOT work over the internet or a wide ara network. If online usage is required, you will either need to use a remote desktop connection or similar such as Citrix OR place the backend in an online environment such as SQL Azure.

Please clarify your exact needs