Update Records to Linked Table

J

Jerry

Is it possible to update records to a linked table in Access? We link
to tables on our SQL Server and I'd like to be able to update some
records using an Access frontend that we already have instead of
creating a new application in VB. When I currently try to update a
record it says that another user has modified the record since I opened
it but no other user has it open. It also doesn't give me the option to
save anyway.

Thanks!
 
R

Rick Brandt

Jerry said:
Is it possible to update records to a linked table in Access? We link
to tables on our SQL Server and I'd like to be able to update some
records using an Access frontend that we already have instead of
creating a new application in VB. When I currently try to update a
record it says that another user has modified the record since I
opened it but no other user has it open. It also doesn't give me the
option to save anyway.

Thanks!
Click to expand...

Try adding a Timestamp column to the table on SQL Server. This is a common
issue when updating a SS link from Access.
 

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

Macro for Sharepoint List and another Table?? Same # records? 1
Linked SQL Tables don't report Cascading Updates and Deletes 2
Unable to update a linked table 2
Record-Locking remains open after closing 0
Linked Excel File won't update 1
Error 3157: "ODBC - update on a linked table <table name> failed 4
Update Query from Access 2003 Linked Table 1
Missing Records in Linked Table 2

Top