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
 
G

Guest

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

Snowflake to SSIS 0
How to connect to oracle odbc data source 1
Connecting to data sources 3
Access 2003 not linked to Oracle 11g 3
Connect string to SQl data 1
Connect to C5, with ODBC from a Nt service 0
Data Source connection failing 0
Finding the backend tables for a front end ? 4

Top