?
Solved

How to convert Access database to a web app?

Posted on 2016-07-14
3
Medium Priority
?
3,562 Views
Last Modified: 2016-07-29
I have an access database I would like to make accessible online. Is Sharepoint the best way to do that? Is there another way by converting the Access database to SQL?
0
Comment
Question by:brasiman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 39

Assisted Solution

by:PatHartman
PatHartman earned 600 total points
ID: 41711106
There is no true conversion path from a client/server Access app to an Access web app.

If you need to distribute your app to users not located on your LAN, the far and away superior method is to use Citrix or RDP.  That allows you to leave the app as it is although you could convert the BE to SQL Server if that makes sense.

If you have enough users, it makes sense to host the app yourself.  Otherwise, thee are service bureaus that will host the app for you.

Access is not optimized to use SQL Server (or Azure) over a WAN.  You could do it but it would probably involve massive changes to convert the forms from bound to unbound.  Switching to SharePoint Lists has other problems.  The SharePoint lists are not a true relational database and the performance degrades with more than a few thousand rows in your tables.

If you don't have to make everything available online, you might be able to come up with a compromise that uses SharePoint Lists to pass data between the Access client/server app and SharePoint forms to allow remote users some functionality such as viewing a customer list or part master that the Access app replaces nightly.  Or possibly to do some limited data collection.
0
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 600 total points
ID: 41711148
There's this:

www.eqldata.com

They can host your Access db on the web. It's not free, of course, but it's a quick and easy way if you have only a few users.
0
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 800 total points
ID: 41712722
<<I have an access database I would like to make accessible online. Is Sharepoint the best way to do that? Is there another way by converting the Access database to SQL?>>

  Just to add/clarify a few things:

"Access is not optimized to use SQL Server (or Azure) over a WAN.  You could do it but it would probably involve massive changes to convert the forms from bound to unbound. "

 While that first part is true, there are things you can do to make it work fairly well.   JStreet technologies has done quite a bit of work in this area, and offers some tips and tricks for making that happen:

"Best of Both Worlds"
http://www.jstreettech.com/downloads.aspx

But that leads into the 2nd part; changes are required, almost to the point of a re-write in some cases, which as Pat said, would be considered massive.  it really depends on what/how much of the app you want to make available to users.   It's something you should not dismiss right off.

Access 2007/A2010 Web Databases use SharePoint lists for storing data, and that is a non-starter.  As Pat pointed out, SharePoint lists are not a great way to store relational data.

Access 2013/2016 Web Apps use SharePoint for a the Front End, and Azure for a back end to store the data (SQL Server in the Cloud).   This works well.

But in both cases, these Web versions are "Access" in name only, and are a different animal entirely from a desktop database.  It's not a one for one.  For example, you can't use VBA code in either.

However if your remote users only need basic CRUD (Create, Read, Update, and Delete) of information, then it might work well.   What you do is use the web app for them, and then connect to the Azure BE directly with a desktop database to do everything else (processing, reporting, etc).

 What that looks like is this:
https://msdn.microsoft.com/en-us/library/office/jj250134.aspx

 Your other option is to write a new front end for the web with something like ASP.Net, then point to the back end database that is used by your current app.

HTH,
Jim.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question