Linked tables

[Peter]

My previous table included all the product data plus their pictures. All
worked fine, but the database, thanks to pictures, grew quickly in size. I
wanted to split the basic product table into two tables in two independent
databases for easier file management. Than I linked these to tables from two
databases together in third database with Queries, Forms and Reports only. So
I made Product Query to link product info with its picture back again using
same productID key. It put all the data and pictures nicely together but the
problem is that I cannot add new or edit products data. Problem seems to be
that I am not using only one database (file) with all data tables in it. Is
there a way to link two different database tables and edit them?

 

[Bob Miller]

If you are entering the data in a form based on a query you have to se
the Recordset Type form property to Dynaset (Inconsistent Updates)