How to choose when creating a db ??

[glenn69]

Hello,

I am currently using MS Access 2000 to run a database in a small office. I want to use MySql for the new database.

We would like to have a database that is primarily used from our office (much like Access split database)
We would like to have a database which is also accessible via a website.

I am willing to learn a new programming language if necessary. I've read a bit about PHP with MySql, but am not sure if it fits the bill. PHP appears to be used in HTML for a web site. That part is OK, but what about our local office use? Would we access our local server with PHP using our browser rather than a dedicated front-end?

I'm not really sure about any of this and am looking for a general direction. Thanks

[Niko]

Hello,We would like to have a database which is also accessible via a website.The keyword here is also.

It would be easier to move the access db to a MySQL database with your web host and add a members/users login to access the db. Maybe directory protection or other means. This way employees can access the db at work and at home.

Are you installing MySQL on your intranet or do you plan on putting the database on a hosted site? Or do you mean have the access database on your intranet in sync with the MySQL database with a web host? That will involve some work on the firewall side.