[AccessD] Discovering Access version at runtime-wasAccessXPforms bound to ADO recordsets

So many ways to do anything.

Thanks,

John W. Colby
www.ColbyConsulting.com 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Monday, March 13, 2006 12:08 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Discovering Access version at
runtime-wasAccessXPforms bound to ADO recordsets

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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com