update record in a table

M

Marcus

Hi,

I'm migrating an access database to an SQL Server. I've
started creating a table. Opening it via access, I can add
or delete columns but I cannot change any record, I
receive the message this recordset is not updatable.
How can I make it updatable?

Thank you

Regards, Marcus
 
L

Lyle Fairfield

Hi,

I'm migrating an access database to an SQL Server. I've
started creating a table. Opening it via access, I can add
or delete columns but I cannot change any record, I
receive the message this recordset is not updatable.
How can I make it updatable?
Click to expand...

Primary Key?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
sqlite-odbc write conflict 2
Mail Merge skipping records/sending one at a time 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Adding Heading to Table of Contents after a column break 1
Video Playback Windows 7 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Linked SQL Tables don't report Cascading Updates and Deletes 2

Top