VBA Error in Access 2002

[JIM H]

I'm an Access novice. A small Access 2000 database
stopped working when I installed Office XP. I get a "You
can't assign a value to this object" error from Access
and a VB error "runtime error 1004". It goes to debug
and highlights: set rst = dbs.openrecordset (strSQL).

I've reinstalled the app and downloaded all the updates.

The file works fine on another computer that is running
Access 2000.

Ideas?

 

[GVaught]

It is possible that your computer with Office XP is missing some references
that are on the other computers. Open the database by holding down the Shift
key to bypass any startup forms and operations. Once in the database window
go into the code editor window and check to see if any references are
missing. Tools | References within the VBA Code Editor. If none are shown
missing, go to the Debug on the menu bar and Compile the database. If there
are any problems with any code it will fail and you will get a message.