How to connect to an ODBC data source?

E

Everyman

Hi,

I'd like to have an Access 2003 front end connect to a MySQL database
using ODBC. Can anyone point me to a doc that explains this? I have
a User DSN set up, but can't find any way using the New Data Access
Page wizard to connect to this source.

Is this only way to use accomplish this to write a VB connect
statement?

Thanks
 
B

Bill Mosca

It sounds like you might be skipping a step. Use your ODBC to link to the
source. It will be the last selection in the file type selection dialog box.
Then try creating your DAP.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Connection files and pivot tables 0
Dropping ODBC connection 0
ODBC connection from Excel 2008 on Mac OS X 0
Finding the backend tables for a front end ? 4
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
ODBC Linked Tables 0
Manage ODBC 2

Top