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

Question

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

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

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

Chris Quinn-821458 Hall of Fame Points: 3192 More actions · Answer 1

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)

WILLIAM MITCHELL SSChampion Points: 13766 More actions · Answer 2

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.

jlarsen-748327 Ten Centuries Points: 1150 More actions · Answer 3

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