MS Access 2000 db and Win98

  • Thread starter Thread starter M. L. Harvey
  • Start date Start date
M

M. L. Harvey

I am doing an app in VB that uses an Access database. I
am testing the app on Win98. I had no trouble in the past
when using Access in Office 95 to create the db. Now that
I have converted to Access 2000 and converted my dbs to
Access 2000, when I install the app on Win98, the app
won't run. Apparently (I think) it cannot open the Access
2000 db.

If I install Access 2000 on the target system, the app
then can open the db and works fine. But I cannot count
on my users having Access at all.

Should I use Access 2000 to convert my db to Access 97
format, which might get rid of the problem?

I have used the VB packaging wizard (I have VB 6) in the
usual way to find dependencies and bring all needed files
into the package. Obviously, though, something is not
getting done in the installation.

Any ideas about what is causing this problem?

thanks

M. L. Harvey
 
You are probably needing to include the Jet4 and DAO 3.6 libraries with your
VB app. Windows 2000 and XP will already have these, although there are
update available, but Win98 won't. One work-around, as you noted, would be
to use a Jet 3.5x database file. The folks in the VB newsgroups should be
able to help you create the install package you need with the necessary
libraries included.
 
thanks
-----Original Message-----
You are probably needing to include the Jet4 and DAO 3.6 libraries with your
VB app. Windows 2000 and XP will already have these, although there are
update available, but Win98 won't. One work-around, as you noted, would be
to use a Jet 3.5x database file. The folks in the VB newsgroups should be
able to help you create the install package you need with the necessary
libraries included.

--
Wayne Morgan
Microsoft Access MVP





.
Click to expand...
 
I see a reference in VB entitled "Microsoft JET Expression
Service Type Library" or "msjtes40.dll." Is this the Jet4
library you mention?

thanks

M. L. Harvey+
 
There are actually multiple dlls. Someone in the VB newsgroups could
probably help you much better with this as I am not fully familiar with the
VB setup wizards.
 
Take a look in the Knowledge Base, at http://support.microsoft.com at
article number Q238401. It deals with a problem similar to what you
describe. If that is the problem, you are 'way behind on applying Service
Packs to VB6, so you may encounter other problems as well. Take a look at
the Service Pack situation.

Larry Linson
Microsoft Access MVP
 
Back
Top