How to retrieve ms access database full information version

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

Re: How to retrieve ms access database full information version

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" wrote in message
news:81358bda-873b-4de1-9d6f-cb5f89d1e924@d4g2000prg.googleg roups.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

Re: How to retrieve ms access database full information version

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 KObd@gmx.de
Ich unterstütze PASS Deutschland e.V. (http://www.sqlpass.de)
Nächstes Treffen in Nürnberg am 15.01.2008