How to retrieve ms access database full information version

[Dedalus]

If I want to retrieve a full version information for an ms access
databases, I use (from vb6 code) the "Access.Application" object and
SysCmd method. Whit the number returned by the method I can identify
the service pack applied to database (e.g.
...
SysCmd(acSysCmdAccessVer) = 9 -Access 2000
SysCmd(715) = 2719 ' Access 2000 No Service Pack
SysCmd(715) = 3822 ' Access 2000 SP1
SysCmd(715) = 4506 ' Access 2000 SP2
SysCmd(715) = 6620 ' Access 2000 SP3
SysCmd(acSysCmdAccessVer) = 10 -Access 2002
SysCmd(715) = 2627 ' Access 2002(XP) No Service Pack
SysCmd(715) = 3409 ' Access 2002(XP) SP1
SysCmd(715) = 4302 ' Access 2002(XP) SP2
SysCmd(715) = 6501 ' Access 2002(XP) SP3
...)
Do is exists a method from some library of Ms Access (or DAO or ADO)
permit to identify a full access verion information.
Thanks to all.
Ciao

[Allen Browne]

See:
http://allenbrowne.com/ser-53code.html

The code shows how to get:
- Version of msaccess.exe
- Version of JET
- File format
and so on.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dedalus" <ul****@email.itwrote in message
news:81**********************************@d4g2000p rg.googlegroups.com...

If I want to retrieve a full version information for an ms access
databases, I use (from vb6 code) the "Access.Application" object and
SysCmd method. Whit the number returned by the method I can identify
the service pack applied to database (e.g.
...
SysCmd(acSysCmdAccessVer) = 9 -Access 2000
SysCmd(715) = 2719 ' Access 2000 No Service Pack
SysCmd(715) = 3822 ' Access 2000 SP1
SysCmd(715) = 4506 ' Access 2000 SP2
SysCmd(715) = 6620 ' Access 2000 SP3
SysCmd(acSysCmdAccessVer) = 10 -Access 2002
SysCmd(715) = 2627 ' Access 2002(XP) No Service Pack
SysCmd(715) = 3409 ' Access 2002(XP) SP1
SysCmd(715) = 4302 ' Access 2002(XP) SP2
SysCmd(715) = 6501 ' Access 2002(XP) SP3
...)
Do is exists a method from some library of Ms Access (or DAO or ADO)
permit to identify a full access verion information.
Thanks to all.
Ciao

[Klaus Oberdalhoff]

Hi,

If I want to retrieve a full version information

i use MSInfo (which is most accurate), an MS Application, which normally
sleeps on each Windows XP System (at least if Office is installed)

additionally i use a modified version of the SysInfo which you get as a free
sample from ATTAC Consulting

http://www.groupacg.com/ACGFree.htm

--
mit freundlichen Grüßen aus Nürnberg

Klaus Oberdalhoff KO**@gmx.de
Ich unterstütze PASS Deutschland e.V. (http://www.sqlpass.de)
Nächstes Treffen in Nürnberg am 15.01.2008