February 27, 2009 at 7:40 am
How do I update the data in an SQL Server table from ACCESS. Apparently you cannot use linked tables to update the SQL server; you need a stored procedure. Does anyone have a short simple piece of code that will get me started?
March 2, 2009 at 7:31 am
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
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
You might want to explore pass through queries. I believe they will let you run DML against your SQL Server DB.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply