J
Jacek_M
My DAP (Data Access Page) enables update of underlying joined base tables by
specifing Unique Table property of Recordset.
This works fine with (as described in
http://msdn2.microsoft.com/en-us/library/ms680834.aspx):
UseRemoteProvider=False
connectionString: Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist
Security Info=True;Initial Catalog=XXX;Data Source=LOCALSERVER;...
if it is changed to:
UseRemoteProvider=True
connectionString: Provider=MS Remote.1;Data Source=YYY;Remote
Server=https://www.wwwremoteserver;
it is only possible to update fields of underlying table which is specified
with Unique Table (one or the other NOT both!!)
The sructure of data base is the same (tablles, rights etc.)
Any hints?
specifing Unique Table property of Recordset.
This works fine with (as described in
http://msdn2.microsoft.com/en-us/library/ms680834.aspx):
UseRemoteProvider=False
connectionString: Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist
Security Info=True;Initial Catalog=XXX;Data Source=LOCALSERVER;...
if it is changed to:
UseRemoteProvider=True
connectionString: Provider=MS Remote.1;Data Source=YYY;Remote
Server=https://www.wwwremoteserver;
it is only possible to update fields of underlying table which is specified
with Unique Table (one or the other NOT both!!)
The sructure of data base is the same (tablles, rights etc.)
Any hints?