Home / Swingerschatfree / Updating linked tables in ms access

Updating linked tables in ms access

However, if the design of the table in the source database changes, you must relink the table to Access.

You must also unlink and relink any table if your user ID or your password changes.

I did a compact and repair and now the MDB file is small.

When attempting an update to a table from SQL Server, for example, we would receive the following error message: ---------------------------------------------------- ODBC -- update on a linked table failed.

[Microsoft][SQL Server Native Client 10.0][SQL Server] Transaction (Process ID 66) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. (#1205) ---------------------------------------------------- Our concern is that we think Microsoft will make another attempt at pushing this update which will again break our solutions.

I have a set of linked tables (To Oracle DB) that I need to update via a form.

Up to now, I have had pretty straightforward forms that basically relate to one table.

486 comments

  1. Oct 2, 2012. Learn when you should use linked tables and when not to. If you ever need to update a lot of records at once, say, increase pricing on all items by 10%, you're much better off doing the update via a pass-thru query or. Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP.

Leave a Reply

Your email address will not be published. Required fields are marked *

*