Micrsoft Access 2003 to PHP/MYSQL

[m4tt1986]

Hi all,

      I would say I only know basic PHP/MYSQL knowledge but am eager to learn.

 

I have written a database in Microsoft Access 2003 and would like to know if it is possible to convert it to PHP/MYSQL, so that it can be used online.

 

I have managed to use a program called Bullzip - MS Access to MYSQL. It has transfered the tables to MYSQL but I now need to configure the front end.

 

Could any one give me any pointers on how to do this or inform me if I am going in completely the wrong direction and if there is another way.

 

It might help if I explain that the database is going to be a customer management system for my insurance agency in Spain. If any one knows of a free php script that is available I would also be interested in that as well.

 

Kind Regards

Matt 

[Cep]

If this is a custom database then any scripting for it would need to be customised as well, hence there will not be any free scripts available.

 

If your using PHP then you need that to create the front-end, normally creating XHTML pages. You could also use PHP-GTK for a more desktop client environment but I feel that may be a bit beyond you current knowledge of PHP.

 

You could connect MSAccess2003 front end to the MySQL backend in which case you do not need PHP.

[trq]

If all you want is simply a web based database administration tool for mysql you might check out phpmyadmin.

[m4tt1986]

My server already has phpmyadmin.

 

CEP - I think I have confused you slightly.  I want one of the following:

 

1) A pre-built contact management script which is designed for the insurance market. (Must be free)

 

or

 

2) Some way of creating a front end. But I would prefer telling my access database how to connect to the MYSQL database (Which is what I think u were telling me, if so how do I do this)

 

Is upsizing anything to do with it.

 

Thanks

[trq]

To answer 1, have you searched google?

 

To answer 2, you need to learn php. Theres a good link in my signiture. No one is going to write a tutorial right here specific to your exact requirements.

[Cep]

The first is most likely not going to be free or easy to find, which is why a custom script is more likely a necessary step.

 

As thorpe has mentioned you would likely need to learn php to write a custom front end for your database.

 

However as I mentioned you could just use the link table manager in Access and modify your Access forms if you would prefer to use the existing front end you have, and in this case you would not need PHP and are best to look around for an MS Access forum such as Utter Access.