Access database online

Posted on 2014-11-26
Medium Priority
Last Modified: 2014-11-28
1) What is required to host an Access Database 2007-2010 on a public MS Windows Server based website for a) viewing data b) updating data?
2) Does the database need to be converted to MS SQL Server to provide proper security.
3) Does the functionality regarding 17 data entry forms, 1 custom query and 10 reports require reprogramming into .net code?
4) This job is for a Non-Profit organisation. I have completed a basic .Net programming course as part of my IT degree so is it feasible that I could convert the database and re-code the functionality?
5) What logical steps would you suggest for me to a) convert it or b) get a quote for an experienced .Net programmer to convert it?
Question by:ditterz
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
LVL 11

Assisted Solution

melmers earned 800 total points
ID: 40468409

you can use the MS Access database as source, but i would recommend that you switch to an
SQL Server because of better security and support for ORM mappers like Entity Framework.

Yes the converting to a web app don't work out of the box, so you have to recode it.
What are your options ?
1.) Create a normale ASP.NET Application
2.) Create a ASP.NET MVC Application
3.) Use Lightswitch

When you only have data entry forms then it could possible and easy to use Lightswitch to
create an Silverlight / HTML Client Lightswitch application. This is easy if you ave no complex
logic. Then use option 3.)

If you have experience with the MVC pattern and are in the need to create a flexible solution
then use the option 2.)

The option 1.) is a fallback if you have experience with Forms programming that you learned
in your curse then you can use this option too, but there are many pit falls you can made
when you want to create highly dynamical web sites.

Your logical steps need to be:
Look at the database and show what to need to be done
  - create tables
  - analyze query how it works
  - analyze the forms and the vba code
  - analyze how the users are working with the database ( are there any direct table edits ? )

If your gahter all the requirements then you can see if you can do this?
But i think when your database is not to complex a professional .NET developer will
create you a better solution in a shorter time as you can. Because when you need to
learn, at first SQL, ASP.NET / MVC / Lightswitch, how to configure the IIS. You will need
several weeks to get a good running application and you can't work on other things for
your organisation.


LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 400 total points
ID: 40468432
You can host the database file but not the Access program.  You need to use the appropriate programming language and drivers to make it work like a 'web app'.  For a 'web app', Microsoft SQL Server or MySQL are better choices.  They are designed for the kind of multiuser operation that is expected of a web site.
LVL 58

Accepted Solution

Jim Dettman (Microsoft MVP/ EE MVE) earned 800 total points
ID: 40468777
Actually, there is a service that allows you to host an Access DB basically "as is" and have remote users use it through a web browser:


The other option not mentioned is to run it on a terminal services server.  Again no changes as everything runs on the server.  Users remote in and only Keyboard, Video, and Mouse (KVM) goes across the wire.

Beyond that, Access 2013 does offer web apps, but they are somewhat limited at present.  However depending on your requirements, they may fit the ibll.  Typical setup is a "hybrid" design where you have the web front end for data collection and updating, then a desktop backend for processing/reporting.

  The web apps are run by SharePoint, and the data lives in SQL Server.

  If web apps will not do the job, then your only option left is a re-write as the others have said.


Author Closing Comment

ID: 40471216
I think that all these answers are helpful. We probably won't be redeveloping the application unless funds are provided, but these answers helped me explain the situation to the developers and users so thank you all, Terri.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

777 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