Hi,
I am an IT guy in Rockville, Maryland and have a custom programming question that has to do with database management. I am trying to integrate a Microsoft Access database with a SQL Server 2008 64 bit database. The SQL Server system doesn’t seem to connect to Access. Do you have any ideas about what could be the problem?
Joe in Rockville, Maryland
Joe,
There is no 64 bit Jet driver. What you want to do is run your SSIS packages in 32 bit mode, and you should be able to connect to the Microsoft Access database no problem. Let me know if you have any other computer consulting questions and good luck.
Will- CCD,LLC