Access database online

Posted on 2014-11-26
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 200 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 100 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 200 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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

724 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