cannot edit record set

  • Thread starter Thread starter Steven Cheng
  • Start date Start date
S

Steven Cheng

i am trying to update some records in my ADP Access database which i recently
converted. the tables have been migrated to SQL express and i can import
data to all tables, however, when i can't simply open them and make edits. i
even tried to create a form to do the same thing but came across the same
problem.

i am still a newbie to the sql express environment so any and all help is
appreciated.
 
i am trying to update some records in my ADP Access database which i recently
converted. the tables have been migrated to SQL express and i can import
data to all tables, however, when i can't simply open them and make edits. i
even tried to create a form to do the same thing but came across the same
problem.

i am still a newbie to the sql express environment so any and all help is
appreciated.
Click to expand...

Each table must have a Primary Key defined in the SQL environment in order for
Access to allow editing. It can often help to add a Timestamp type field (also
called Rowversion) - you don't need to DO anything with it, even include it
any of your queries, and it's not really any sort of timestamp, but it helps
SQL identify changed records and IME can sometime make a difference in
updateability.
 
Back
Top