Importing Records from an ODBC source

[Guillo]

Hello Everyone:

I'm having an annoying problem trying to import records from a ODBC Data Source. The scenario is as follows:

I have a very big Access database that I need to convert to FM. So I set up an ODBC data source on Windows 7, using the ODBC Data Source Administrator, Using the Microsoft Access Driver.

Neither the Access file itself or the ODBC authorization have a password set up, however, when I open my FM database, go to File -> Import Records -> ODBC Data Source and select my previouly created Source, I get a Dialog, asking for username and password.

I Can't import anything because I cant get pass that dialog. I repeat, the Access file is not password protected, but FM keeps asking for a password. I lefted it blank, tried my PC user and pass, used the default "Admin" username, nothing. Any Ideas?

Thanks!

[amader7000]

odbc server is having password and username

[Guillo]

Found the Issue:

It's the 64 bit ODBC Access Driver. If you need to do something like this (creating a ODBC source for importing Access data) you need to use the 32 bit ODBC driver. Go to C:WindowsSysWOW64 and find an exe named "odbcad32.exe". This is where all the old 32 bit odbc drivers are located. Create your ODBC source from that executable and you will be able to Import the data from it.

Thanks Anyway!