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?