Results 1 to 2 of 2
2003-08-18, 09:07 #1
- Join Date
- Jun 2003
- Thanked 0 Times in 0 Posts
Reports will not work in Copy of Database (2000)
They do work when I access them remotely on the other server, but when someone there opens the database and clicks on the "ROUTES List" button which should let them preview and/or print the reports, they get an error message as shown in the attachment. They have the same version of Access as I, and some even have exactly the same computer. Any ideas?
2003-08-18, 09:52 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
Re: Reports will not work in Copy of Database (2000)
This kind of error is usually caused by missing references. It can only be solved on the PC where the problem occurs.
<UL><LI>Activate the Visual Basic Editor (Alt+F11)
<LI>Select Tools | References...
<LI>If one or more references start with MISSING, note their description in the lower half of the References dialog.
<LI>Clear the check boxes of all MISSING references.
<LI>Test if the report will open now.
<LI>If not, you will have to find out where the files for the missing references are located on that particular PC, and set new references for them.[/list]Post back if this doesn't solve the problem.