ODBC Driver

[elias.farah]

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.