Post reply

INSERT, UPDATE, & DELETE SQL Server data from Microsoft ACCESS

  • March 2, 2009 at 7:31 am

    #951857

    You can update using linked tables, but each table must have a unique identifier, otherwise Access will give read only access.

    If the table does not already have a column that is uniques, add a new column of type Int to the tables, set them as Identity = Yes in the table definition, and add a unique index based on the unique column (or set it as the primary index)

  • March 29, 2009 at 9:25 am

    #968019

    I'd like to add that if you are using bound forms in Access, you will also need to add that unique field to the underlying data source, otherwise you will be able to edit but you won't be able to add new records.

  • March 30, 2009 at 10:28 am

    #968500

    You might want to explore pass through queries. I believe they will let you run DML against your SQL Server DB.

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply