I'm using pair as a webhost. I've created a mysql database with tables. As of now there is no data in the tables but they are set up to retrieve data. I am trying to access the database via odbc through micrsoft access but the connection won't go through. Is it something on my part. I haven't altered any of the default settings. I'm getting "error 3146" and "call failed". I'm using odbc driver 3.51.

Here is a good tutorial on accessing MySQL databases in Microsoft Access:

http://www.ucl.ac.uk/is/mysql/access/