UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Which version of Jet Engine Access 2002 is using...    
 
   
z_crito
post Dec 21 2003, 10:16 PM
Post #1

New Member
Posts: 4



I'm trying to find out which version of Jet Engine my Access 2002 is using.
I'm new to Access and recently purchased and installed Access 2002 on my Win 98 machine. I created a test access database (xyz.mdb) and then tried accessing it via VBScript with:
-------------------------------------------
Set objConn = CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Database=abc;" & _
"Data Source=C:\access_data\xyz.mdb"
------------------------------------------
That doesn't work and VBScript says "ADODB Connection. Provider cannot be found. It may not be properly installed".
But this one works:
------------------------------------------
Set objConn = CreateObject("ADODB.Connection")
objConn.Open "DRIVER=Microsoft Access Driver (*.mdb);" & _
"Database=abc;" & _
"DBQ=C:\access_data\xyz.mdb"
------------------------------------------
My ODBC Data Source Administrator shows for "Microsoft Access Driver (*.mdb)":
File: odbcjt32.dll, version: 4.00.6205.00, date: 11/12/03
(is version 4.00 and the date a good sign ??)
My Registry shows under HKEY_LOCAL_MACHINE:
\SOFTWARE\Microsoft \Jet\ => shows an entry for 3.5 and 4.0 (but no Engines for Access).
--and--
Microsoft\Office\10.0\Access\Jet\ => shows an entry for only 4.0 but no data under this section.
Otried loading and then reloading Access 2002 on my PC hoping a different install would prompt for Jet installation. It never did.
I also downloaded and installed all the latest MDAC and Jet 4.0 (sp8) software from microsoft's download web page. I must have all the latest Jet files on my PC by now.
So, how does one determine which version of Jet they are using, and if it's not the right one then how to tell Access to use the latest version ?
(again I'm new to Access and any help would be appreciated. That friendly paper clip only moves about and smiles at me and at times looks like it's even taking notes but hasn't given the answer.)
Thanks!
Go to the top of the page
 
+
R. Hicks
post Dec 21 2003, 10:29 PM
Post #2

UA Forum Administrator
Posts: 40,126
From: Birmingham, Alabama USA



Access 97 uses Jet 3 and all versions newer than Access 2000 and higher uses Jet 4.

RDH
Go to the top of the page
 
+
mishej
post Dec 21 2003, 10:50 PM
Post #3

Retired Moderator
Posts: 11,289
From: Milwaukee, WI



You might find some additional helpful info at Tony Toew's page:
http://www.granite.ab.ca/access/verifyjetsp.htm
Go to the top of the page
 
+
z_crito
post Dec 21 2003, 10:53 PM
Post #4

New Member
Posts: 4



Thanks for the quick response R.Hicks!
ccess 2000 and above will always use Jet 4.0, they can't use older versions?
There's no real way to see and confirm one's Access is using Jet 4.0 ? or even which version of 4.0 ?
Thanks again!
Go to the top of the page
 
+
mishej
post Dec 21 2003, 11:16 PM
Post #5

Retired Moderator
Posts: 11,289
From: Milwaukee, WI



I don't have A2002 - I'm using A2000 but perhaps the steps are the same?
Select Help, About Microsoft Access, System Info - this opens a separate utility (at least with Office 2000).
Click on Applications, Microsoft Office Environment, OLE DB providers to get more specific info...
I have 4.0.6807.0 of the Microsoft Jet 4.0 OLE DB Provider (for A2000). HTH.
Go to the top of the page
 
+
z_crito
post Dec 22 2003, 12:12 AM
Post #6

New Member
Posts: 4



Thanks "mishej" for your response, too!
Well I've never checked my system layout via the "system info" button (thanks for some new info.)
Odid, and there's no appl section but only
1.hardware
2.components
3.software environment
4.internet explorer
the best I could find is under software env which does list drivers and 32-bit modules loaded.
this shows a long list of DLLs were the only ones concerning OLE DB are:
name version descrip
OLEDB32.DLL 2.60.6526.0 Microsoft Data Access - OLE DB Core Services
OLEDB32A.DLL 2.60.6526.0 Microsoft Data Access - OLE DB Core Services
MSDAPS.DLL 2.60.6526.0 Microsoft Data Access - OLE DB Interface Proxies/Stubs
MSDART.DLL 2.60.6526.0 Microsoft Data Access - OLE DB Runtime Routines
I checked all sections and didn't see anything mentioning Jet 4.0, Microsoft Jet 4.0 OLE DB Provider or even Microsoft Access.
(but my ODBC Data Source Administrator does show for "Microsoft Access Driver (*.mdb)":
File: odbcjt32.dll, version: 4.00.6205.00, date: 11/12/03 )
that 4.0 version for that 32-bit dll may be the answer.
Thanks for your quick responses and help. I'll keep looking...
Go to the top of the page
 
+
robcooper
post Dec 22 2003, 01:42 AM
Post #7

Microsoft Corp UtterAccess VIP
Posts: 1,839
From: Bellevue, WA



Shy of System Information, there isn't an easy way to see which version of Jet Access is using. As previously mentioned, Access 2000 and later will always use Jet 4.0, they cannot use older versions. The following article will show you which service pack is installed:
How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine
http://support.microsoft.com/default.aspx?kbid=239114
John, that's a great tip about system information. (I always forget about that! smile.gif )
Go to the top of the page
 
+
z_crito
post Dec 22 2003, 11:17 PM
Post #8

New Member
Posts: 4



Thanks for everyone's updates. My problem has been solved.
It was really two parts:
(1) Error 3706: Provider cannot be found
(2) find which version of Jet my Access was using.
For (1) I needed to download and install:
(1) Jet 4.0 Service Pack 8 (SP8) [Jet40SP8_9xNT.exe]
(2) Microsoft Data Access Components (MDAC) 2.8 [MDAC_TYP.EXE].
Then take the connection stuff off my script's (.Open) property and use the (.ConnectionString) instead.
Ocan now read my test Access database via VBScript and Microsoft.Jet.OLEDB.4.0.
For (2), after checking the site Rob Cooper suggested
(http://support.microsoft.com/default.aspx?kbid=239114),
my file "Msjet40.dll" is now at version "4.0.8015.0", so I'm using Jet 4.0 Service Pack 8 (SP8).
(latest and greatest!)
Thanks!
======================
I like this utteraccess.com ==> because its Web page loads fast (via my 56k modem), it's easy to search for problems or open one and responses are good and quick!
======================
Go to the top of the page
 
+
mishej
post Dec 23 2003, 12:59 AM
Post #9

Retired Moderator
Posts: 11,289
From: Milwaukee, WI



Thanks for posting back - we all learned from your situation. UA is a great site - hang around; you'll find it very useful wink.gif
Go to the top of the page
 
+
rdevanat
post Jan 19 2005, 08:53 PM
Post #10

UtterAccess Addict
Posts: 156
From: Australia



Hi mishej,
I have an error called: error 3014, cannot open any more tables. I am using Microsoft Office 2000......with Jet 4.0....is there a way I can deal with this error.
Ounderstand it is making references to tables, and currently exceeds the capacity.....most probably to do with bad database design...
Its just that I have 1 more day to hand in a project, and I get these errors.........so I was wondering whether I could install a higher version of Jet and solve this problem for now......
Cheers
Go to the top of the page
 
+
khaos
post Jan 20 2005, 08:43 AM
Post #11

Retired Moderator
Posts: 8,589
From: Lansing, MI



Are you closing all objects like recordsets etc? This is probably the culprit. There are jet patches for 4.0 as well. I know 8 is the latest but am not sure if that is for Access 2000. Also the general Office patches are very much needed for Access 2000. Sr1 is a must but running up to sp3 is highly recommended.
TH
Ken
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 26th November 2014 - 04:50 AM