Help with subreports and odbc connections

[shortstuff2212]

I have got a report which has two supreports in it. When a customer tries to run it they get an error message. Cannot open SQL server. This runs fine on my machine. I have pinned it down to the odbc connection but I can't figure out what I have done wrong. The connection when designing the report is VMLive\db1.mdb. The customer is connecting via VMCrewe\db1.mdb. Have I done something wrong and is there a way around this?

Thanks in advance.

 

[BlurredVision]

He/she could rename the dir to match yours, or have them reset the location of the db within the report. Brian

http://www.crystalinfo.net