I am getting this error "User-defined type not defined"

[Gezza]

Hi All,

I am getting the error when I compile the database
I have tried selecting the Microsoft DAO 3.6 Object Library in User references but this has not worked

Hope someone can help,

 

[HiTechCoach]

What line of VBA code gets highlighted?

 

[Gezza]

HiTechCoach
Thanks for your reply

That is part of my problem, there is no code being highlighted when the error appears, it does not matter which form or module I am in.

 

[boblarson]

If you open your VBA code window and then go to DEBUG > COMPILE <yourProjectNameHere>, it will take you to any errors you have in code. Do that and it should highlight the error (and it will also highlight any other errors you have).

 

[Gezza]

Hi boblarson,

Yes that is what I have done, but it does not highlight the problem code. I think the problem may be with my editing the data base from two different versions of Access 2002 at work and 1997 at home.

I have gone back to a prvious backup copy of the file and will only edit code at work for now, until I intall 2002 at home

 

[boblarson]

I think the problem may be with my editing the data base from two different versions of Access 2002 at work and 1997 at home.

That could do it. It is really best not to be trying to modify a database with such disparate versions.