Missing broken reference

[JimfromNYC]

I am getting the following error message

Your Engineering Work Request database or project contains a missing or
broken reference to the file 'PPCTL401.OCX' version 1.0

any idea what that means, I wrote the database in 97, people may have opened
it using 2000, and now we have 2003. I have not tried to convert the database
because I split the database to have the tables in a back end database and
the users have their modules so the forms load faster.

 

[John W. Vinson]

I am getting the following error message

Your Engineering Work Request database or project contains a missing or
broken reference to the file 'PPCTL401.OCX' version 1.0

any idea what that means, I wrote the database in 97, people may have opened
it using 2000, and now we have 2003. I have not tried to convert the database
because I split the database to have the tables in a back end database and
the users have their modules so the forms load faster.

It means that - at some point - someone added a reference to this OCX file,
and the file is no longer available where Access expects to find it.

Open the database holding down the Shift key to bypass any startup. Type
Ctrl-G to open the VBA editor; select Tools... References. Find the row in the
references marked MISSING (with this reference named). Uncheck it (and uncheck
any other MISSING references).

Select Debug... Compile <my database) and see if any errors pop up - there
might be some code which needs the OCX in which case you have more work to do,
but hopefully it wil clear the problem.

Close VBA, compact and repair, and you should be good to go.

John W. Vinson [MVP]

 

[JimfromNYC]

John, you are the man, you fixed my database, the other error I was getting
went away as well and now my macro's work.. Thank you sir.....