How to determine Jet database Engine Type programmatically
Posted
by MZB
on Stack Overflow
See other posts from Stack Overflow
or by MZB
Published on 2010-05-24T14:41:53Z
Indexed on
2010/05/26
20:41 UTC
Read the original article
Hit count: 308
I have a program which needs to upgrade any Access (Jet) database it opens to JET Version4.x if it isn't already that version. (This enables use of SQL-92 syntax features)
Upgrading is (relatively) easy. A call to the JRO.JetEngine object's CompactDatabase method (as described here) should do the trick, but before I do this I need to determine whether an upgrade is required. How do I determine the Jet OLEDB:Engine Type of an existing database? Can this be determined from an open OleDBConnection?
Note:
- I'm talking about database versions, not Jet library versions.
- C# or .Net solution greatly appreciated.
© Stack Overflow or respective owner