Hello out there:

Let me describe what leads up to the "1526 connectivity error" I am getting.

I have a project based on VFP 7 and MM7
I have some tables set up from scratch in SQL2000, populated from Excel using DTS.
I have created and tested a connection to the SQL db.
I have created a remote view, rv_address_edt, based on this connection and through this view I am able to see and (manually) edit the SQL data. This is the initially selected alias in the DE. This DAO is set to remote
In addition I have two list views that are used to populate a couple of combo boxes. One is local and one remote.
The preference set on the app is for local data (so that the logon screen will appear).
I have constructed a simple maintenance form based on cBizObjForm - nothing flash, smart or liable to incite a riot.

When I compile and run the project I can see the sql data, I can scroll through it, the combos work fine.

If I edit and then try and save the data, I can trace the save right up to the point where, in ov_address_edt.save, it disappears into the tableupdate() function below (parameters .F., .F.)

loSelect = This.SelectAlias()
IF CURSORGETPROP("BUFFERING") != DB_BUFOFF
	IF TABLEUPDATE(tlAllRows, tlForce)
		lnRetVal = FILE_OK
	ELSE
		*--------------------------------------------
		*-- Return error number of what went wrong
		*--------------------------------------------	
		=AERROR(laError)
		lnRetVal = laError[AERROR_ERROR]
	ENDIF
ENDIF
RETURN lnRetVal

It comes back straightaway with the returned error 1526 "connectivity_error"
The changesare rolled back and the "error" is attended to.

What gives?

Could it be that I have used the wrong form object? Am I overlooking a silly mistake somewhere? Is the government to blame?

I would appreciate any help that anyone is able to give.

TIA.