Hi!

Can anyone let me know how to determine which version of Microsoft Jet is 
installed on a PC. I am finding that a networked database is 
intermittently giving the 'Needs Repairing' error message or 'Unrecognised 
Database Format' error message and since there are a number of users I 
would like to check that they are all using Microsoft Jet 4.0 as it is an 
Access 2000 database. By the way, if theye are on a previous version, is 
it straight forward to download and install version 4.0?

Many thanks,

Paul

                                                                                         
                    hcb@g...                                                        
                    .co.uk               To:     "Access" <access@p...>          
                                         cc:                                             
                    25/03/2002           Subject:     [access] Microsoft Jet Version     
                    12:30                                                                
                    Please                                                               
                    respond to                                                           
                    "Access"                                                             
                                                                                         
                                                                                         








Hi!

Can anyone let me know how to determine which version of Microsoft Jet is
installed on a PC. I am finding that a networked database is
intermittently giving the 'Needs Repairing' error message or 'Unrecognised
Database Format' error message and since there are a number of users I
would like to check that they are all using Microsoft Jet 4.0 as it is an
Access 2000 database. By the way, if theye are on a previous version, is
it straight forward to download and install version 4.0?

Many thanks,

Paul



Try
  DBVersion = DAO.DBEngine(0)(0).Properties("Version")

Joe Dunn


*************************************************************************

This e-mail may contain confidential information or be privileged. It is intended to be read and used only by the named
recipient(s). If you are not the intended recipient(s) please notify us immediately so that we can make arrangements for its return:
you should not disclose the contents of this e-mail to any other person, or take any copies. Unless stated otherwise by an
authorised individual, nothing contained in this e-mail is intended to create binding legal obligations between us and opinions
expressed are those of the individual author.

The CIS marketing group, which is regulated for Investment Business by the Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965  - for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for ISAs and investment products bearing the CIS
name
Registered offices: Miller Street, Manchester M60 0AL   Telephone  0161-832-8686   Internet  http://www.cis.co.uk   E-mail
cis@c...

CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank p.l.c., registered in England and Wales number
990937, P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of the
Bank.

CIS is a member of the General Insurance Standards Council

CIS & the CIS logo (R) Co-operative Insurance Society Limited

********************************************************************************

> Can anyone let me know how to determine which version of Microsoft Jet is
> installed on a PC.

Check for msjet40.dll in c:\WINNT\system32 for version 4.0.

>  By the way, if theye are on a previous version, is it straight forward to
download and install version 4.0?

This will depend on which version of MDAC you have on the machine, check
out:

http://www.microsoft.com/data/download.htm

Thanks for the quick reply but I'm afraid that I do not understand it! 
Where do I click and what do I type please? Sorry for being a bit slow!

Many thanks,

Paul

The code:

    CurrentDB.Version

returns the version of jet that you are currently using.

If you put the following line of code on, say a form load event, a message 
box will appear when the form loads that tells you what version of jet is 
running.

    msgbox CurrentDB.Version

Hope it helps, Kind regards, Phillip

> Thanks for the quick reply but I'm afraid that I do not understand it! 
W> here do I click and what do I type please? Sorry for being a bit slow!

> Many thanks,

> Paul