I would like to know how to read information stored in a Firebird Database and use it in an MS Access 2007 application that I'm about to write. The Firebird database will not be updated via MS Access 2007.
A:
This is a real problem, and you're not the only one asking. Access has native support for ODBC, which is ok for getting things in and out, except when the ODBC driver is dodgy. Near as I can tell, there really isn't a concept of OLEDB interfaces in Access, and it appears doubtful that you "can get there from here". Believe me, if I do find an answer, I'll be back here in a heartbeat to update this post.
Avery Payne
2010-09-29 22:48:40