program to identify access fileversions ?

[Guest]

Is there a program out there that will identify an access file I have
?? so that when our version needs change ?

oh and is there an faq or other just out of interest how many versions
have there been - I assume someone else could point me in the right
direction

thanks Keith

 

[Allen Browne]

If you are talking about how to deploy changes to your front end database to
each workstation, Tony Toews has an Auto Updater utility you can download
from:
http://www.granite.ab.ca/access/autofe.htm

If you are talking about knowing which version of Access is running, you can
just use:
=SysCmd(acSysCmdAccessVer)

If you want to know which version and service pack, see:
http://www.mvps.org/access/api/api0065.htm

If you wanted to know if JET (the Access query engine) is up to date, you
would use the functions in the list above, and combine them like this
(assuming Access 97 or later):
=fGetProductVersion(fReturnSysDir() &
IIf(SysCmd(7)="8.0","\msjet35.dll","\msjet40.dll"))

The versions of Access are:
1, 2, 95 (7), 97 (8), 2000 (9), 2002 (10), 2003 (11)
The number in brackets is the internal version number.

 

[Guest]

On Thu, 2 Mar 2006 12:06:41 +0800, "Allen Browne"

thanks Allen - what great info - and quick too

so now I have to think about what I *actually* want - first thing is I
am seeing if a certain membebership-card producing program is suitable
, for now and into the future

it can use an simple-fla-9file-type-access file (not sure which
version) it can produce its own which works OK. The rest of the
organiation uses excel and doesn't want to go near access,

I could install access 2000 (or even '95) to check - or as you say
use one of the tool you mentioned.And then if they upgrade this
card-proggy or use a later access to change the file to a leter
version.

I guess what I was hoping for was a link to a stand-alone that didn't
require me to have access or whatecer --- that may indeed be the links
you include, I will check them out right now - it takes a little while
for my head to get around the simplest things.

thank you

Keith

 

[Guest]

If you are talking about how to deploy changes to your front end database to
each workstation, Tony Toews has an Auto Updater utility you can download
from:
http://www.granite.ab.ca/access/autofe.htm

If you are talking about knowing which version of Access is running, you can
just use:
=SysCmd(acSysCmdAccessVer)

If you want to know which version and service pack, see:
http://www.mvps.org/access/api/api0065.htm

If you wanted to know if JET (the Access query engine) is up to date, you
would use the functions in the list above, and combine them like this
(assuming Access 97 or later):
=fGetProductVersion(fReturnSysDir() &
IIf(SysCmd(7)="8.0","\msjet35.dll","\msjet40.dll"))
--------
The versions of Access are:
1, 2, 95 (7), 97 (8), 2000 (9), 2002 (10), 2003 (11)
The number in brackets is the internal version number.

oh good ta - cool, No wonder you are still up so late you are in
West Oz , me an easterner (sp ??) ok nsw

I'll have to think back or look at my notes as to where
=SysCmd(acSysCmdAccessVer) goes - some query - I'll have a go at it
right now (I had installed access 2000 [version 9 ] after all !!)

thanks
Keith