>Hi Erik,
>I've rarely (if ever) come across an error that CONSISTENTLY crashes in Production and NEVER crashes in Development. Right now, my data paths are relative to the location of the executable application. That's how I flip between live and test environments.
>
>Thanks, Shuli
You need a routine that loops through the cursor objects in your DE and changes the database property of each view and contained table based on the contents of a global variable or application object property. This has to be done before the cursors are opened, so it has to run from Form.Load (with DE.AutoOpentables = .F.) or from the DE.BeforeOpenTables event. There shold be some code here in the knowledgebase that demonstrates this, but if you can't find it, let me know and I'll post some for you.
Erik Moore
Clientelligence