I think Matthew meant that his ISPs MySQL installation is firewalled, and so access via MyODBC would be impossible. This makes sense for an ISP to do - I would be a little surprised if I found that my ISP allowed incoming ODBC connections to their database server.You can just install MyODBC on the client (running MS Access) then you can link tables stored anywhere.
have a look at: http://forums.devshed.com/t56700/s.html
for more info
Hope that helps Nitin
If this is in fact the case, Matthew's best bet would be to use mysqldump to dump the data to a comma delimited file, and import that into Access.
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
