Re: How to retrieve ms access database full information version
- From: "Ralph" <nt_consulting64@xxxxxxxxx>
- Date: Wed, 19 Dec 2007 11:58:27 -0600
"Dedalus" <ulysse@xxxxxxxx> wrote in message
news:d645ae08-6525-45e4-8f18-4a24b79f06a6@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi at all.
I want to retrieve the full version information from a access database
via vb6 codes, similar "Select @@version" in Sql server from obtening
also the information relative to service pack number applied.
Thanks.
Ciao.
Your question was somewhat misleading, but understandable. MSAccess is a
separate Front-End Applications which uses Jet to access a MDB formatted
file. ie, while SQL Server IS the database, MSAccess is a Office product.
All that is important to a data access library and provider is what version
of Jet format the mdb file is using.
To get the information you want you will have to go two routes.
One, read the registery entries. Which means seeking out the
"Access.Application" PID and then back-tracking it through the installed
components.
The other is using SysCmd which I have used successfully on occasion.
http://www.everythingaccess.com/tutorials.asp?ID=Undocumented-SysCmd-Functions
But note just as the author states - this is a *hack*. It has occasionally
failed for no clear reason. <g>
There is another more direct way using the Object Model, but I don't have
the MS Access OLE Automation Guide handy. The SysCmd is a bit better than
the Automation version as IIRC the object model doesn't return all the
details such as SPs. <?> But I could be wrong. You might try one of the
Access newsgroups. I'm sure someone there can help.
hth
-ralph
.
- Follow-Ups:
- References:
- Prev by Date: Re: How to retrieve ms access database full information version
- Next by Date: Re: How to retrieve ms access database full information version
- Previous by thread: Re: How to retrieve ms access database full information version
- Next by thread: Re: How to retrieve ms access database full information version
- Index(es):
Relevant Pages
|
