Charlotte Foust
cfoust at infostatsystems.com
Mon Mar 13 11:07:43 CST 2006
John,
What you want is DBEngine(0)(0).Version
Charlotte Foust
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
Sent: Sunday, March 12, 2006 8:48 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Discovering Access version at runtime
-wasAccessXPforms bound to ADO recordsets
LOL, Thanks Stuart. Now if I could only find the FM.
John W. Colby
www.ColbyConsulting.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Sunday, March 12, 2006 10:52 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Discovering Access version at runtime -
wasAccessXPforms bound to ADO recordsets
On 12 Mar 2006 at 22:18, John Colby wrote:
> >John, you want to check the version and then load code based on the
> version?
>
> Yes, the ACCESS version. I have found stuff about checking the
> registry, but this really only addresses what is INSTALLED, not what
> is currently running.
>
RTFM? :-)
Version
Returns a String indicating the version number of the currently
installed copy of Microsoft Access. Read-only.
expression.Version
expression Required. An expression that returns one of the objects in
the
Applies To list.
Example
The following example displays the version and build number of the
currently-installed copy of Microsoft Access.
MsgBox "You are currently running Microsoft Access, " _
& " version " & Application.Version & ", build " _
& Application.Build & "."
--
Stuart
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com