Ho to use MS Access database over the web


Can anyone advice me of the best solution to use an Access Database over the web?

LillyCDatabase DeveloperAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Lee W, MVPTechnology and Business Process AdvisorCommented:
Depends on your resources.

Create a web page that accesses the tables.
Setup an RDP connection to a system on the remote network.

I would not DIRECTLY access the database via VPN as remote connections are not usually as reliable as the lan and a disconnection could potentially corrupt the database or record.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<Can anyone advice me of the best solution to use an Access Database over the web?>>

  Depends on what you mean by "over the web".  Couple different ways:

1. Use SQL Server for data storage.   Client has an Access "Front End" (what you typically think of an an app) to Access the data.   Using SQL Server avoids the corruption issues that you'd have with a MDB/ACCDB file.

2. Host it as is on a server with Terminal Services or Critix.   In doing so it executes on the server and only KVM (Keyboard, Video, and Mouse) goes over the internet.   App may or may not appear in a web browser.

3. Use the service www.eqldata.com to host your app.

4. rewrite your app using Access Web Apps - Web apps run on a SharePoint server with a SQL Server back end (storage of data), but their use it limited at this time.  Usually you do a hybrid design where you have the web app for some users and then a setup like #1 for other users.

5. rewrite your app as a true web application with something like ASP.NET.

 Each has advantages and disadvantages.   Fill in some more details on what you'd like to do, what your goals are, etc.

Don't.  Jet and ACE are not optimized for web access.  Move the data to SQL Server or some other RDBMS that works well with web pages.

Of course if you are talking about the application rather than the data, that is a whole different problem.  Even though Access 2013 supports web apps served by SharePoint, there is no conversion from an existing app to a web app.  You would need to completely rewrite it.  You can convert the Jet/ACE tables to Azure but that's it for the conversion.

Tell us more about what you have and where you want to go and why.  Access web apps are significantly inferior to Access client/server apps.  There are many features that are not supported starting with VBA.  Your only option is macros so if it can't be done with a macro, it can't be done, period.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"Even though Access 2013 supports web apps served by SharePoint, there is no conversion from an existing app to a web app."
Well, that's not completely true. It's true for the front end UI, but not the back end ... wherein your entire table structure and relationships (hopefully) will be automatically directly ported into a full blown SQL Server (Azure) database (hosted by Microsoft) - when you initially create an A2013 Web App. However, the front end is another story entirely.

I believe that is what I said.
Luke ChungPresidentCommented:
For a limited number of users, Remote Desktop or Remote App is a good solution that lets you extend your desktop solution for people to use over the web. It lets people on tablets and Macs use our app as well.

Using Terminal Services and RemoteApp to Extend Your Microsoft Access and other Windows Applications Over the Internet

We have additional whitepapers, tips and resources in our Microsoft Access Developer and VBA Programming Help Center

Hope this helps.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.