I did some quick searching and came across this incredibly helpful article. Much to my suprise, there was no Access driver listed in the manager. I opened up my System32 folder and found the 32 bit ODBC executable, odbcad32.exe and launched it. I am running Windows 7 64 bit, and from prevous experience I know that I should be creating a 32 bit ODBC connection and that Windows provides both a 64 bit and 32 bit ODBC manager. I needed to create an ODBC connection to the Access database first so that I could query the data in my report. I had to create a report today that used information from two different data sources, the first was SQL Server, and the second was an Access database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |