Need to move an ms access database to the web

[Niko]

Hi,

Where I work we have an access database with around 20 tables each with 3-20 fields. We would like to move it to our web site so we can work on it from home. We have already checked with our web host and we have a mysql database available to us.

Can anyone help us meet this goal?

[Jenn]

Hello,

May I suggest the database tools at websitedatabases.com which makes this an easy task.

Access-PHP-MySQL-Magic allows you to store your Access database in a PHP script, by running this PHP script once in your website, you will be able to Import your Access database to your MySQL database.

Open and review your access db(note that the table names and column names names in your access db should not have spaces or hyphens - mysql won't accept them). I would suggest adding an auto increment field to you access tables if you do not already have one. It's not required but would come in hadny should you wish to run queries later on.

Now open PHPMagic or PHPMagic Plus and create the table(s) and fields that match your access db exactly(spelling and text case U/L) also be sure to set the datatype of your fields.

Once you have created the project file with tables and fields that match your access database exactly spelling and punctuation. Generate -> upload -> run the generated setup.php file.

Now run the Access-PHP-MySQL-Magic software. Generate a php dump file of your tables. Save as whatever.php and upload to the same folder your uploaded your generated phpmagic files.

Now through your browser run the whatever.php you created using access to mysql to populate the database with the access data.

You can now manage your database via the web with PHPMagic.

Hope this helps