It may be that the form is "finding" the wrong database. Try...
1) In the DE BeforeOpenTables method for each cursor object add...
This.CursorObjectName.Database="\\serverpath\dbcname.dbc"
2) Set the cursor's NoDataOnLoad property to .T.
3) Then when you need the data, set the paramaters and the issue a
lcParam1 = whatever1
lcParam1 = whatever2
=REQUERY('CursorAlias')
HTH,
Larry Long
>Hi
>
>Heres my problem.. I have an app that uses 2 remote sql server views to display some data in a grid.If i run the EXE locally it works fine however trying to run it from a mapped network drive it errors out loading the form with a 2005 error loading the data environment. So I know it has something to do with loading the view but not sure why. If I open the database on the server i can open and browse the remote view without any problem.
>
>Thanks,
>
>Paul