I'm working with a client who doesn't have a constant connection- and thus needs to work locally on an access xp database- but wants to be able to run queries on this db by uploading it to their site.
This information will be changed twice a day.
I can export an entire database to mysql online, but I'm having problems then updating it.
I don't seem to be able to export the db out again- as it won't replace the old one thats there.
Can anyone help- maybe suggest a more tenable way of doing this?
How id php and odbc? Should i consider using that and simply uploading the .mdb file?
Hope you can help.
Many thanks,
Iain.
This information will be changed twice a day.
I can export an entire database to mysql online, but I'm having problems then updating it.
I don't seem to be able to export the db out again- as it won't replace the old one thats there.
Can anyone help- maybe suggest a more tenable way of doing this?
How id php and odbc? Should i consider using that and simply uploading the .mdb file?
Hope you can help.
Many thanks,
Iain.