What the world happened!

[SemiAuto40]

I took my 2003 MDB secured database and imported it into a new one on another PC running Access2010 thus creating a accdb file so that I could work on the manual permissions deal. Now I'm at work and the database will not allow me to add a record! The error that I get is:

Compile error:
User defined type not defined

Dim MyConnection as ADODB.Connection is what is highlighted as the offending code.

What the world!? Please?

[pdebaets]

ADO is not referenced in the new database.

Open any module in design mode, then click Tools > References.

Put a check mark next to "Microsoft ActiveX Data Objects 2.x Library".

For more, please see http://allenbrowne.com/ser-38.html

[SemiAuto40]

SUPER! PDEBAETS I'm sure glad there are individuals who are so willing to come to the rescue of beginners! Problem Solved!