DB on local machine and on the internet

panosa73

Hi,
I'll get right to the point. There's a Access database on the local machine. Then, there's a mySQL database on the internet. Both dbs contain items and their prices. When my client makes a change, like changing an item's price or adding an item, on the Access db on his local PC, he wants to easily be able to reflect that change to the mySQL database.
My question is: can I and if yes, how can I access a database on a local machine when, since I am doing this with PHP, the code is executed on the server.

Any other ideas will be appreciated.
Thanks
Panos A

barand

Update mySQL table via internet. Link your access database to the tables in the mySQL db via ODBC (tou can download myODBC from mySQL.com .

That way, using the access db you always see the latest version of the data. This is one thing access is good for.

panosa73

Thank u very much 4 replying barand.
I downloaded and installed myODBC like u said. So now I'm sitting in front of the screen thinking "what the heck do I do now? 😕 ." How do I link these two DB's? If u can direct me or if there's a tutorial that I can study somewhere it would be great.
Thanks again for your responce
Panos A.

barand

Open your control panel and find the ODBC Data sources control. If you have win2K its in admin tools.

Open the control and click the system dsn tab. Click Add button, select mysql driver. Give the new DSN a name (you'll use this name in the later to link db's.) and enter other details, like mysql server name.

In access, create a blank database. Select link tables from menu or right click in blank area of tables list and select it. Choose the odbc option at the bottom of the dropdown list then specify the ODBC DSN you've just created. Select the files. Click OK.

Thats it. Access now behaves as though the files are in the same mdb. The difference is that the table icons have an arrow to show they are linked.

hth

BeastRider

You mean to say that I can supply an ODBC link to an external MySql database located at www.myhost.com way on down the DSL line, and then use that link to created a linked table in a local copy of Access?

Can you point me to the docs (MySql?) that shows me how to create the external ODBC link?

TIA

barand

I was assuming an internet server on his network.

panosa73

so there's no way to do this since the db is located at mysql.somehost.com.
i already tried what u said and got a database-server-not-found error.

thans agaim for ur help
Pamps A

panosa73

I tried again the next day and it worked.
Once I figure out why all the fields of the database that was created by the linking have the value #deleted I'll be set.
I think I have some idea. I found a useful link.
http://www.washington.edu/computing/web/publishing/mysql-access.html
Thank you very much for your help Barand. 😃

Panos A