J. Adams wrote:
-----Original Message-----
[...]

I got help from a another newsgroup. The reference was
set to DAO 3.51 I switched it to DAO 3.6 and moved it
above the ADO references. I also had to fully qualify my
objects like so:

Dim db as DAO.Database
Dim rst as DAO.Recordset

After that everything worked fine.

Thanks for your response Frank. I appreciate it..

hi
though this is definetly not my area of expertis you should consider
'late binding' to prevent such errors in the future. I'm quite sure
someone else could post some good references on this topic (Dave, Bob,
Tom, etc.)?

Frank