You then provide Access with the means by which to bring the divided information back together — you do this by placing common fields in tables that are related.

ms access linked table not updating-81

Suppose you have a one-to-many relationship between Shippers and Orders and you want to delete a Shipper.

If the shipper you want to delete has orders in the Orders table, those orders will become "orphans" when you delete the Shipper record.

For example, employees can be associated with orders for which they are responsible by creating a table relationship between the Employee ID fields in the Employees and the Orders tables. Employee ID appears in both tables — as a primary key ... There are several reasons why you should create table relationships before you create other database objects, such as forms, queries and reports.

When you design a database, you divide your information into many subject-based tables to minimize data redundancy.

One of the goals of good database design is to remove data redundancy (duplicate data).

To achieve that goal, you divide your data into many subject-based tables so that each fact is represented only once.

It's as if the application has taken a snapshot of the data and refuses to update it's view.

Oddly enough, I can update linked tables via SQL statements from the app.

Hourglass True If Refresh Local Database = 0 Then Msg Box "Unable to refresh local database.", vb OKOnly vb Exclamation, Current Db. File Exists(str Source) Then fso.copyfile str Source, str Dest Do Events Refresh Local Database = 1 Else Refresh Local Database = 0 End If Exit_Handler: Set fso = Nothing Exit Function Err_Handler: Call Log Error(Err. Yes, I stepped through the code in debug mode, nothing errors out.