Microsoft Jet ver used in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Do you know how to check the version of mdb file and the Microsoft Jet used in Access??
So that I can create the proper version.

I was trying to open a database file somedb.mdb with DAO, but the program
throws an exception saying the format is unrecognised. So I use the DAO
create command to create a new mdb file and everything is OK. With the
create command, the default version is 3.0 and I do not know which version
of Access file it created for me. I'm using Access 2000, so everytime I open
the mdb, the Access will ask me to convert the file to the current version
of Access.

DO
 
Have a look at this

ms-help://MS.MSDNQTR.2003JUL.1033/enu_kbvstudio/vstudio/178880.htm

It gives you the versions released with the s/w and the versions of the
DLL's to look for.

Not sure how you determine the version of an MDB though .. ..
 
JohnFol said:
Have a look at this

ms-help://MS.MSDNQTR.2003JUL.1033/enu_kbvstudio/vstudio/178880.htm

It gives you the versions released with the s/w and the versions of the
DLL's to look for.

Not sure how you determine the version of an MDB though .. ..
Click to expand...

From the debug window:

? Access.Version
11.0

or:

? Application.Version
11.0

or:

? SysCmd(acSysCmdAccessVer)
11.0

That tells me I'm running Access 2003. The format of the database though is
the default (Access 2000).

for DAO, I can do:

? DAO.DBEngine.Version
3.6

Which tells me the version of DAO I'm running.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top