Missing Broken Reference

[JMBAccess]

Database built in v. 2000, placed on network with user level security. Some
users have upgraded to 2003 and get error message on opening "Missing or
Broken Reference to ..., ...must fix". The original DB is still v. 2000 as
not all users have upgraded yet. I have cleared the check box on the list of
Missing References (v.2003)but not allowed to save this. I can see these
references on the original db v. 2000 (they were not intentionally used for
any reason in the original database). After the user enters OK to each of
the error messages, the database opens fine. I am unclear how to fix the
broken reference or remove the error messages. THANK YOU

 

[Douglas J. Steele]

Are all of your users trying to open the same database? That's never a good
idea. It should be split into a front-end (containing the queries, forms,
reports, macros and modules), linked to a back-end (containing the tables).
Only the back-end should be on the server: each user should have his/her own
copy of the front-end on their hard drive. Doing that, you'll be able to
create a version for 2000 users and one for 2003 users. However, you really
should remove any references that aren't being used.