By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,497 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

How to retrieve ms access database full information version

P: n/a
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

Dec 20 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Dec 20 '07 #2

P: n/a
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

Dec 20 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.