Access 2000 not recognising Recordset

[richied123]

Hi, as you can see I'm up early trying to sort this one. I created a database on my PC (Access 2003) on one network, then converted it on my PC and transferred it via CD to another (PC and network, Access 2000). Due to problems I wanted to create a new database on the new machine and take all the tables, forms etc from the old database.

However, having done this when running the code it stops when it reaches the recordset. The current references I have are VBA, DAO 3.6, ADO 2.7, Ole Automation, and Access 9.0 library.

Help much appreciated.
Richard

 

[richied123]

It seems that restarting the computer and leaving it over the weekend has done the trick.