Convert Microsoft access into a Web based database application?

Question

I have a Microsoft Access program, with linked tables, and various forms, queries and tables, which i want to export into a web based system
I am not a programmer and looking for a low cost solution
any thoughts ?

Answer 1

Microsoft has tools to scale up an Access database into a SQL database, but you'll still have to recreate the interface for the web. If you have no programming experience, it will be quite a challenge. You may want to take a class or two to get started. Or, you could hire someone - this would be the easiest for you, but obviously would cost the most money.

Answer 2

Importing the data into a RDBMS (e.g. MySQL) on a web server should be simple enough but reproducing the forms, queries and display code in the web based system (e.g. PHP) would take a fair amount programming knowledge.

The lowest cost solution would be to choose a platform (LAMP, ASP/MSSQL, Ruby on Rails, ... the list seems to grow by the week) and pick up a book on the subject.

You might find a CMS that does that exactly what you are looking for.

Other than that, you could always seek out a freelance programmer with experience on this sort of thing.

Answer 3

you probably dont have a program, you have a MS Acess file, and the program that you are talking about can be done in the .net platform ( check asp.net ) ,there are a free tool for this ( google Microsoft Web developer express edition) and you might ( or a developer ) do a web app. You will need a server thought or some host that run under window ( there are several of those )
Good luck, any quiestion let me know, I am doing a e-commerce site at this moment using ASP.net

Answer 4

I would expect most modern web based systems will use MySQL or Microsoft SQL and should thus be capable of importing a database direct from Access.

Check it out with the Database Administrator.

Answer 5

There is no low-cost solution. You'll need to hire a programmer to recreate the system, probably using ASP.NET