By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,161 Members | 1,048 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,161 IT Pros & Developers. It's quick & easy.

ODBC Driver

P: n/a
Hi Everyone,

I'm having a lot of trouble with Access 2007 / Vista x64 creating a
new ODBC table.

Existing ODBC tables are fine, and connect - however creating a new
ODBC tables via the visard gives me password errors, depite being able
to run odbcad32.exe from the SysWOW64 directory, and testing the
connection - giving "success".

I suspect the Wizard in Access 2007 is firing the odbcad32 in the
System32 directory, which is the 64 bit ODBC driver administrator. I
can't find where to change the string to ensure Access 2007 fires the
correct version of the ODBC admin application, as MyODBC is only 32
bit.

Alternatively, does anyone know of (or have code) to just create a
table from scratch, that way I can just specify the DSN details into
the table, and it will probably just work.

Thanks for listening!

Elias Farah.

Aug 14 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.

Browse more Microsoft Access / VBA Questions on Bytes