- Convert Microsoft Access Database To Web Application
- Convert Microsoft Access Forms To Web Application
Active1 year, 5 months ago
Converting Access 2013 to a web app I have an Access database with forms, queries, tables (some are linked), and reports that I would like to convert to a web app. This new app I am trying to create needs to be accessible from multiple iPads, so people can enter information into a form to add to the tables. 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. Mar 22, 2016 In this video we'll learn how to convert an Access Database to a web application using Caspio Online Database platform. Try Caspio f. Open Access, and select Custom web app. Enter a name for your new web app, and select its location. Then, select Create. Add structured or blank tables to the web app, or create tables from existing data sources.
As per requirement, we need to convert the existing MS Access database to a web application. Is there any easy way to convert the MS Access database to web application? As of now they are inserting the data to access db using access Forms. User also wish to continue access form feature even if we create new web application for the same. That means user should have the option to access the MS access database through Access forms as well as web application.
Please guide me away to solve this issue.
Best Regards,Ranish
RanishRanish42322 gold badges66 silver badges2424 bronze badges
2 Answers
Convert Microsoft Access Database To Web Application
You can use Office 365 and have somewhat of a web-based application.
Or, store Access in SharePoint, but your functionality will be quite limited. Keep in mind, no VBA will run on a web-based application.
The alternative is to use SQL Server Express, and ASP.NET, both of which are free from Microsoft. I'll tell you now, though, the learning curve will be quite steep if you have never used these technologies before. This combo, however, will give you the most control!
Convert Microsoft Access Forms To Web Application
You can get the .NET framework from here.
You can get SQL Server Express from here.
user7075507
First of all, Database and Web Application are not mutually exclusive.
![Office Office](https://www.pulsesolutions.com/wp-content/uploads/2016/01/mac-image2.jpg)
Back to original question, I have done multiple projects like that. A client started with small Microsoft Access database with a couple of user; then they migrate to to web application when they get more traffic.
At first, you want to convert data from MS Access Database to SQL Server. MS Access Database is not meant to access multiple users simultaneously. Then you develop the Web Application which uses SQL server as back end database.
Right before you go live, you convert the data again from MS Access Database to SQL Server very last time. Then do not let them use old MS Access Database anymore.
Easy way to convert the MS Access database to Web application
Most of the time whoever created MS Access database are not software engineer, so table are not normalized and do not have relationship at all. I normally create new normalized database in SQL Server. Then write a small program to convert those data from MS Access to SQL database. Dell 1100mp manual.
WinWin![Convert Convert](https://support.content.office.net/en-us/media/07713438-b0e6-4490-94bc-509767159578.jpg)
48.1k99 gold badges7373 silver badges144144 bronze badges
Not the answer you're looking for? Browse other questions tagged c#asp.netms-accesssharepoint or ask your own question.
I would recommend you look into if there is a pre-built web app for this. There likely is. The TCO on it might well be much less than recreating/maintaining the wheel.
If you move forward with building your own, Ruby on Rails is going to be one of the best bets. I would still be looking to have it hosted in the cloud as the TCO, performance, etc will be much better than in-house.
However, you will note that asking for best programming tools/languages is kind of like asking for which is best, Ford or Chevy, which is almost entirely preference.