Problems when moving from win 2000 to win 98

Hello, I'm relatively new at this so I'm hoping there is an easy solution! I developed a database application using vb 6 and access 2002 on a windows 2000 machine. My vb program just displays data that is in the access database and allows the user to add new records, delete records and update records. On my development machine it works fine. I have an adodc control and the data is displayed in a data grid.
:
: When I move my exe and mdb and access and vb runtime files to a win 98 machine, it does not work correctly. I'm getting the error "Runtime-error 91, Object Variable or with block variable not set". I believe the error is occuring on "Adodc1.Recordset.Requery". The form never even gets a chance to load the data into the datagrid. If anyone would please be able to give me some pointers I would really appreciate it! Thanks again,
:
: Bob

Did you install the correct MDAC on this win98 machine?

I don't know for sure that it is relevant to your specific problem, but there are definite known problems with backwards compatibility (basicially it is very flaky) between Access 2000 and Access 98. If your problem is one of those problems, there is no solution that I know of. You have Microsoft to thank for that.

I've installed version 2.7. Does it matter if that is the same version of mdac that's on the development machine?

My database is an access 2002 database. I've distributed the access run time files with it as well so my understanding is that the 98 machine should not even need to have access installed.

You have to have the MDAC for the version of Access AND the components used in Access ...

Phinds has a point ... Access 2002 may not be compatible with win98 ... A test of it would be to try to install it and run Access from there ...

Bob,

Distributing the runtime files doesn't do jack ... It's the MDAC ...

And no, I don't do rap ...:D

The Jet library is not included on MDAC version 2.6 and above.. Just a reminder...:o

A little risky (there is a small change you may damage your Win98 installation) but try to create a setup in Win2K for your application (so all the necessary libraries will be included in it), then install it in the Win98 machine and then try to run your app from within VB. Hopefully it will work.

Thanks everyone for all of your help! I got it to run on 98 by building a package with the P&D wizard and then installing it that way! I guess just moving the vb exe and runtime files is not the best way to do an install!

One more question though...If my vb application only uses ms access as a backend database, does the client machine need to have access installed? Do I need to load the access runtime files or is mdac sufficient? Thanks again for all of the help!

Bob

Bob,

Again ... It's the MDAC. That is all that is needed to access an Access DB ... You do not need to install Access or Office XX to work with an Access DB. If you want the interactive frontend of Access then you'll have to install it ...

Sounds good. Thanks for all the help!

Bob