Wednesday, March 7, 2012

Recordset not updatable

I use MS Access Project to connect to MS-SQL 2000. Even though I login as ow
ner of the database, I can't update my table with message 'Recordset is not
updatable'.
I have no problem updating through Enterprise Manager. Someone out there. Pl
ease help meAccess needs unique index to update a table. When linking SQL tables Access
may ask you to select index columns. Select the number of columns needed for
an "unique index"

No comments:

Post a Comment