Oh, if that's the case, I'm sorry for false info. Of course, if server is not accessible, then you cannot connect to it anyway, directly or through Access.
Sorry again Nitin ----- Original Message ----- From: "Daniel Kasak" <[EMAIL PROTECTED]> To: "Nitin Mehta" <[EMAIL PROTECTED]>; "Matthew McNicol" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, January 09, 2004 10:02 AM Subject: Re: odbc > Nitin Mehta wrote: > > >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 > > > > > > > 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. > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]