Thank you, Mr. Scott, for your reply. It was very specific answer. Do you know if using NAC local storage will solve the problem? Honestly, I watched many Youtube's on this but no one specifically touched on the reliability of that option. Have you?
MS Access for Internet sharing among Users
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
There are many ways to share desktop Microsoft Access for multiple users' simultaneous access. I am not talking here about sharing MS Access in the same network. I need to share it among several users outside my network. What is the cost-effective solution that I can use, and how? I tried using SQL Server to share the MS Access tables, but kept having several technical problems, as some MS Access codes are not so compatible. Any idea what other solutions that I can use at a very low cost? I don't want to jump into expensive solutions. Any help?
Microsoft 365 and Office | Access | Other | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
{count} votes
15 answers
Sort by: Most helpful
-
Anonymous
2025-04-23T21:59:19+00:00 -
Anonymous
2025-04-23T22:04:24+00:00 You mean NAS? No, Access can't be shared over the Internet reliably.
You already know the various possible approaches. You may not like any of them, but those are you only choices.
I still don't get why you wouldn't use SQL Server. If you explain the issues you were facing people here would be glad to help you resolve them.
Another typically low cost way to share Access over the net is to migrate the backend to MySQL, but that also will require modifications to the front-end.
-
Anonymous
2025-04-23T22:27:22+00:00 Thank you Mr. Daniel,
Whenever I share the MS Access tables in the SQL server, I get the MS Access file not working. It keeps popping up an error message that I contacted MS help with, and they could not solve it. The error says, "Run-time error '2427'. You entered an expression that has no value". Apparently, the error is caused by an incompatible expression. With my big Access file and many tables, queries, forms, macros, modules, reports, etc., it is unknown where exactly I have to look for such a compatibility issue and how to fix it. I called MS help three times. I ended up with a waste of time, nothing more.
-
Anonymous
2025-04-23T22:46:39+00:00 How did you upsize your database to SQL Server?
Did you install the latest SQL Server driver, and not use the default Windows ones?
"Whenever I share the MS Access tables in the SQL server, I get the MS Access file not working"
Please explain how you are sharing the tables.
Does the error occur when you open the database, open a form, a query, a table directly?
-
Anonymous
2025-04-23T22:55:51+00:00 Hi, Mr. Daniel,
I am using the latest SQL Server app. The error messages pups up when I open any form, save any form, run any query. It is almost in every button I press.
Also, I lost all attachments inside the tables.