Hi Nigel

The EXPSVR.DLL file is required for the Jet Engine to operate. This file 
is included in the MDAC 2.6 file. Or, you might try to find it on 
Microsoft's Web site, but that proves to be quite a convoluted quagmire to 
wade through, just to find a file.

Email me directly so we can discuss a solution in a more timely fashion.

Fred

fred.lutz@m...



> Hi Fred,
> Thanks for the info.
> I checked each of the .dll files in the C:\Windows\System Folder (win98)
> Every file you listed was present, except for one.
> It was the EXPSVR.DLL
> 
> Will I actually need to load these .DLL's even though they are already
> present in this folder?
> I presume you mean to load them within VB and run VB to temporarily 
register
> each one thus checking them individually.
> If the code from my app is then run and the compacting then works, then
> register the .dll component that is being loaded by VB.
> 
> I must admit that I'm not too knowledgeable about .dll's, and as a result
> can you explain how 
> to check the file dependencies exist for these files?
> MSVCRT.DLL
> OLEAUT32.DLL
> 
> What does EXPSVR.DLL do? and why is it missing, then how can I get it?
> 
> Thanks for all of your advice.
> 
> Nigel.
> 
> > -----Original Message-----
> > From:	Fred C. Lutz [SMTP:fred.lutz@m...]
> > Sent:	Friday, March 23, 2001 6:43 PM
> > To:	professional vb
> > Subject:	[pro_vb] Re: Compacting An Access Database With VB
> > 
> > Nigel
> > 
> > The problem is not that it can't create an object, exactly. I had this 
> > same error message when trying to open an Access 2.0 database in 
> > Windows2000, using a VB6 app. 
> > 
> > You will possibly need to install additional MSJet .dll's:
> > Check to see that these files exist in Windows\system (Winnt\System32):
> > MSJET35.DLL
> > MSJTER35.DLL
> > MSJINT35.DLL
> > VBAJET32.DLL
> > EXPSRV.DLL
> > 
> > Also check to see if these file dependencies exist: 
> > MSVCRT.DLL
> > OLEAUT32.DLL
> > 
> > This is a JET ISAM driver, which you can check if you need, too:
> > MSRD2X35.DLL
> > 
> > I loaded the files one at a time until my app successfully ran. You 
will 
> > need to register them manually after you load them:
> > REGSVR32 c:\windows\system\<filename>
> > 
> > Referenced Knowledge Base articles:
> > Q240377
> > Q245524
> > Q244040
> > Q244264
> > Q247440
> > Q189366
> > 
> > Hope this is of some help..
> > 
> > Regards,
> > Fred C. Lutz
> > fred.lutz@m...
> > 
> > 
> > 
> > 
> > > Hi Everyone,
> > > I am trying to compact an Access 97 database from with Vb.
> > > I have copied the code from the MSDN help and put it into a code 
module.
> > > The code looks fine, but when it runs, I get an error 429, cant 
create 
> > > ActiveX object. I have made a reference to both DAO and ADO but 
still 
> > this 
> > > happens.
> > > The line of code in question is where
> > >      DBEngine.CompactDatabase dbCurrentLocation, dbNewLocation
> > > 
> > > Could this be because the Database is a newer version that this code 
was
> > 
> > > originally designed for?
> > > 
> > > Any help or pointers?
> > >