Unique Table Property..please help

[dwight1]

Hi,

I have a form that is based on a SP. When the user tries to enter the data it is read only as i have not set the Unique Table Property. Can any one please help on this???

Dwight

 

[cmmrfrds]

Only 1 table can be updatable in an sql server recordset. The unique table property tells ADO which table this is. The query you are using must be joining tables.

 

[dwight1]

cmmrfrds,

It means we cannot have a form that is based on a query that has two or more tables joined unlike MS Access. That is very strange. I have tables like customerinfo, wireinstructions,fundingtable. I have fields from all the three tables that are added/edited/updated by the operators. I cannot make them use this. What is the solution for this? Please.

Can you tell me, how do i fill in the name of the table in the unique table property? I typed in the name of the table in the property sheet of the form under Unique Table line. Did not produce any results?

Thank you

Dwight

 

[cmmrfrds]

This is probably because the recordset produced by the query does not have an unique index for the table. The table in sql server must have an unique index. Check the sql server table. This field must be included in the query.

Another way is to put a timestamp field in the sql server table. A timestamp is always unique. Even through you don't ask for the field in the query, sql server will include the field hidden in the recordset and can assure uniqueness that way.

 

[cmmrfrds]

On multiple tables to be updated in a query. Possibly the latest version of Access ADP has a way to update multiple tables. I am not sure. The other approach is to include the tables as Sub Forms in the Main Form and link the sub form tables to the table in the main form.