PDA

View Full Version : Convert Microsoft access into a Web based


whoknowsinlondon
03-31-2007, 10:30 PM
database application? 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 ?

Steve B
03-31-2007, 11:30 PM
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.

Clear Line Web Design
04-01-2007, 01:45 AM
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.

MamaBean
04-01-2007, 02:45 AM
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.