VFP 6 data Upsized to SQL 2000.

[knopmike]

When I run my app and click on the menu that causes my 'do form ...', code to run, i get the following error message below:

Application Error!

Error: 2005 - Error loading file - record number 10. Frmnebscreen1 <or one of its members>. Loading form or the data environment: Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'act_regulation'
Line: 104
Message: DO...
MethodProgram: MAINXING

I've done the following to try to resolve, to no avail:

- checked the connection
- set step on in the beforeopentables event and the system bombs sometime after this event, but before the form load event
- deleted and re-added the remote views to the data environment
- modified and ran the remote views that the form is based on
- looked at the control source of all of the objects on the form
- re-upsized the data
- checked the updateable fields of the views

Additional Info:

- the line that the program reports below is the &quot;read events&quot;
- &quot;act_regulation&quot; is an upsized table that does not occur in the data enviornment; however, a remote view called vwact_regulation based upon &quot;act_regulation&quot; does
- Frmnebscreen1 is my form object

Any help received would be appreciated.

Thanks.

Mike

 

[foxdev]

Gosh, Mike, you've already done so much troubleshooting; congratulations for a really good post!

To try to narrow this down, open your form file as a table and look at record 10. For example:

[tt]use myform.scx noupdate
goto 10
browse [/tt]

By looking at what object this is, as well as the contents of some of the code sections (those with Memo), we might be able to identify the problem. -----------------
Robert Bradley
use coupon code &quot;TEKTIPS&quot; for 15% off at:

http://www.lowcostprints.com

http://www.foxdev.com