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!

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

Unique Table Property

Status
Not open for further replies.
BBDBA

BBDBA

MIS
Jan 4, 2003
3
US
I am developing an application with MS Access Project and SQL Server 2000. I am trying to update a table that is related to another table through a join table. I get an error saying that the fields are read-only because the UniqueTable Property is not set. There are no choices in the drop-down box of the Properties pages and it won't accept typing in the name of the table. Does anybody have insight as to what I'm doing wrong or how to use the UniqueTable Property.

Thanks,

 
Status
Not open for further replies.

Similar threads

OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
732
OCM
OCM
renigar
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
396
renigar
renigar
Moss100
  • Locked
  • Question
Using data macro to alert user when record is added to a table.
Replies
2
Views
114
Andrzejek
Andrzejek
clevercat88
  • Locked
  • Question
Field in table will not filter - info update
Replies
0
Views
110
clevercat88
clevercat88
PrimoSteve
  • Locked
  • Question
You must use the dbSeeChanges opion with OpenRecordset when accessing a SQL Server table
Replies
9
Views
232
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top