Access Service Patch version thru VBA

[Lauren Quantrell]

Is there a way to determine the Version of Access running and the
current Service patch thru VBA Code?
lq

[MGFoster]

Re: Access Service Patch version thru VBA

Lauren Quantrell wrote:
[color=blue]
> Is there a way to determine the Version of Access running and the
> current Service patch thru VBA Code?
> lq[/color]

You can get the version this way:

debug.print SysCmd(acSysCmd AccessVer)

Don't know about patch numbers.

MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

[Mike Sherrill]

Re: Access Service Patch version thru VBA

On 12 Dec 2003 08:53:30 -0800, laurenquantrell @hotmail.com (Lauren
Quantrell) wrote:
[color=blue]
>Is there a way to determine the Version of Access running and the
>current Service patch thru VBA Code?[/color]

I'm pretty sure the only really reliable way to determine SP levels is
by using API calls to get the version numbers of the relevant DLLs.

--
Mike Sherrill
Information Management Systems

[John Mishefske]

Re: Access Service Patch version thru VBA

Lauren Quantrell wrote:[color=blue]
> Is there a way to determine the Version of Access running and the
> current Service patch thru VBA Code?
> lq[/color]

Check Tony Toew's page:

http://www.granite.ab.ca/access/verifyjetsp.htm

--
'-------------------------------
' John Mishefske
'-------------------------------