Run-Time Error at once location; works at all others?!?!

[Nate1749]

I've distributed a database file to about 20 different locations, at each location it's running on about 10 machines. At 19 out of 20 locations (on all of the machines) everything works fine. However, at one location on all of their machines they are receiving the same error message

a pop-up occurs when they try to preview a report (behind the preview button is code to get all of the criteria selected from the list boxes on the form to put into a query which drives the report they are previewing), that is a run time error. The pop-up also occurs when they link the file that gets the data for the query. The message is specifically...

Run-time error '-2147220999 (800401f9)':

Method 'Connection' of object '_CurrentProject' failed

It then goes and highlights this line of code, which is in General -> Fill Options

Set con = Application.CurrentProject.Connection


Any clues?

 

[rickgrimes]

Nate:

Check and compare the references. Maybe they have an outdated library file, or even corrupt. The fact that it is a connection error, I suspect ado?

Just a thought...

Good Luck