Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"Recordset not Updateable - Need to set Unique Table"

Status
Not open for further replies.

xlatb

Programmer
Jan 12, 2001
1
NO
I keep getting this message when joining 3 tables.
I have customers, postalnumbers and customertypes.

Customers.Postalnr relates to Postal.Postalnr(int(key)) where i need to find Postal.AreaName (WHERE Customers.Postalnr = Postal.Postalnr)

Customers.CustomerType relates to CustomerTypes.CustomerType (int(key)) where a simple description Customer.Description (nvarchar(255)).

The problem occurss when i try to make a form out of the Customers table. Access 2000 (From Office 2k pro) and MS SQL7.0 used.

All attempts at making a form either returns a blank form when using autoform or hands back "Recordset not updateable (writeprotected) you need to set Unique Table property"

No where can i find this property, do i need to alter Access' own generated SQL statements to make it work?

I'm not totally lost at SQL, as i've used MySQL with PHP for a while. No books i've read have ever mentioned this problem, and it happens on everyone elses computer too.

I would be thankfull if someone could help me out with this one, it has driven me mad for weeks(!) :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top