February 28, 2005 at 3:17 pm
I have a Access frontend and the tables are linked to a SQL server and when I try to update i Get that error
February 28, 2005 at 3:21 pm
One of reasons could be record is not unique.
February 28, 2005 at 3:43 pm
It even happens if I change the current record that is already in the table. I use the RS. edit and RS.addnew then RS.Update. I think it may have something to do with maybe a permission or a link perhaps
March 1, 2005 at 6:34 am
Did you upsize the Access DB to SQL? Does the table you're updating have a Primary Key? If not then the upsizing wizard will make it read-only...
March 1, 2005 at 7:12 am
Open your linked table in the Access db...check at the bottom where the record selectors are - make sure that the one on the far right (asterick) is not greyed out. This is why you need a primary key on your linked table so you can make changes to it.
March 1, 2005 at 7:35 am
TMSmith is right, but may not have given you enough information.
To fix this, remove the link and reestablish it. Access will ask you to select a unique record identifier. Pick the field or fields that can identify this record as unique. The table will now be updateable.
Shalom,
Michael Lee
Michael Lee
March 1, 2005 at 7:40 am
... Unless you have no suitable field or fields for a primary key. In that case you will have to re-establish the local table (if you haven't deleted it yet it is called "Table Name - Local", just delete the Linked Table and rename the Local Table, otherwise delete the Linked Table and Export the table from SQL to Access). Now you have to create a unique ID field. You can use an Autonumber field. Set that as the key, then delete the table from SQL and run the Upsizing Wizard again just for that table.
Sound like I've been there before?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply