accessing database on a remote host

[sweetleaf]

hi there!

I want to build a simple MS Access database at work that reads data from an the company's web site db (hosted remotely by an isp).

the os of the website is linux and the db is mySql. does anyone know how, using MS access, i can access this remote data from head office?

Thanks a bunch

 

[sixthsense]

hi sweetleaf
there is no way u can access a mysql database from MS access
from the host isp u specified
but if u have the rights to access the mysql database u can
copy the tables and the data to ur local computer in a dump file which will have all the commands to create a new database in mssql from where u can then convert it to msaccess database

hope this helps Kapil Aggarwal

Technical Director
Infovalley Interweb Pvt. Ltd.
Microsoft Certified System Engineer
visit

http://www.interwebspiders.com

If u find the information provided here useful to u then let me know by clicking on the link below s-)