SQL Server does not support Microsoft Access attachment fields. You would need to save them as blobs or save them on some online drive and simply save the paths/url.
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-23T23:11:39+00:00 -
Anonymous
2025-04-23T23:20:17+00:00 Hmm. Ok.
-
![](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(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
ScottGem 68,755 Reputation points Volunteer Moderator2025-04-24T00:21:26+00:00 Did you mean NAS local storage? NAS stands for Network Attached Storage. So it requires a LAN to work. It can be a peer to peer LAN. I use it on my home network and place my back ends on the NAS.
-
Anonymous
2025-04-24T10:27:28+00:00 What I'd do would be create a new database and link the SQL Server tables, then try opening each one.
If you can't open one, then I'd start exploring the details of that table to identify what the source of the issue is.
Did you ensure every table has a primary key defined.
Have you seen: https://support.microsoft.com/en-us/office/migrate-an-access-database-to-sql-server-7bac0438-498a-4f53-b17b-cc22fc42c979
-
George Hepworth 21,805 Reputation points Volunteer Moderator2025-04-24T11:54:53+00:00 Investing sufficient time and effort into learning about the options available and how to approach them should help you reach a viable solution.
Depending on the size and complexity of your particular Access relational database application, the options including either SQL Server or SharePoint lists, along as well as others. None is cost-free, all are viable in the proper context. All require some sort of learning curve, but having gotten to this point, I am sure you can manage that aspect.