The DB's work fine on my wife's laptop so it's not the DB . Someone
mentioned on another group it might be the VB and I thought that too
from the beginning. I ran an aggressive registry cleaner a while back.
Don't have enough restore points to fix it. Can I somehow reinstall
VB?
how do I find out which version of VB I have?
I'm running WinXP home sp3 (came preinstalled with sp2) I have Office
XP 2002 sp3
"espee2" <rnw...@gmail.com> wrote in message
news:7c78aa15-dd2f-46a8...@x1g2000prh.googlegroups.com...
Blaming the VB development platform is a real stretch.
You didn't mention whether this is something that just started happening or
if it has always been this way on this machine, but most likely the Jet
components need to be re-installed. Or you have somehow "touched" these
Access databases and converted them to a different Jet Format from an
expected one.
To re-install the data access libraries download from the following sites.
(While you are at it, go ahead and re-install the latest 'n greatest MDAC.)
"How to obtain the latest service pack for the Microsoft Jet 4.0 Database
Engine"
http://support.microsoft.com/kb/239114/
"Microsoft Data Access Components (MDAC) 2.8"
http://www.microsoft.com/downloads/details.aspx?familyid=6C050FE3-C795-4B7D-B037-185D0506396C&displaylang=en
-ralph
I went to the links you provided... the first one for Jet update,
well, apparently that page was written before SP 3 came out. When I
tried to install the win XP jetpac, I got an error...
..."Setup has detected that the service pac version of this system is
newer than the update you are trying to apply, there is no need to
install this update.
On the second link same thing... error:
.."MDAC 2.8 RTM is incompatible with this version of Windows. All of
its features are currently part of Windows."...
On the jet link, I tried to look for the update version that I
currently have on the MS support, it came with SP3 serv. pac. Can I
reinstal SP3? or do I have to first uninstall it, then reinstall it?
==============================================
==============================================
If you are having trouble with apps accessing MS Access formatted databases
(.mdb), the problem most likely lies with the Jet packages and not the MDAC.
So best to chew on it first. However, just as a reference here are the
instructions for re-installing MDAC on later versions of XP:
http://support.microsoft.com/kb/899861
You can uninstall XP SP3 and see if that fixes the problem. But there is an
important security update included with SP3, so at some point you need to
get SP3 on your machine.
To re-install SP3:
http://support.microsoft.com/kb/322389/
-ralph