Problem with code after Saving Access 2010 Database as 2003

[Redbeard]

I need to save my Access 2010 database in 2003 format so that someone can use it that is only running 2003. My database was built using Access 1997 and has been upgraded over the years to 2003, 2007 and now 2010. The code in question has been there and working since 2003 with no changes, I check back to an earlier version that I had saved. I have pasted the code below. The code is in a Module called “Global Vars” and it does not like line 5 “Global DBase As Database” and line 6 “Global filttogrecset As Recordset”. It gives them the error “Compile error: User-defined type not defined”. If I comment out those lines, it then goes into my forms and has the same error with “Dim rs As Recordset”. There are probably more but that is as far as I got.

I did not program this database, I just manage it and I am not well versed with programing and just have a basic understanding. I done some searching online and have not found much other then there seem to be a lot of problems down grading to an earlier versions. I have read a lot about missing “Libraries” but I don’t know what that means? Anyone have any suggestions?

Option Compare Database
 
Global imagevar As Integer
 
 Global DBase As Database
 Global filttogrecset As Recordset
 
   Global Fc As Form

[Redbeard]

I fixed the problem... there was a missing Library reference which I found by comparing my old 2003 version to the downgraded one from 2010. Missing reference was: Microsoft DOA 3.6 Object Library".

[zmbd]

Well,
You beat me to the answer.


You'll find this to be the case quite often, as the database goes up in versions, the older libraries are replaced by newer and the pointers updates (of as often as not, you have to go in and update to the newer version by hand!Q).