Recent content by Archmike

Thanks for the help, in the end, your advice was right. It works as follows: before I want to update the data, I delete the current info from the table, then remove the primary keys, then append the new data and lastly replace the primary keys again. Very cool for a baby-programmer like me. Mike

I tried it, and it the following problems occur: a) I need a table to be formed in my second database because other tables are built from it. b) The primary key is lost with the query There must be a way of simply replacing the dat in an existing table with new data?!! Thanks though M

Hi Sorry but this is a basic question. I need to update my tables from another (bigger) ACCESS database with new and existing info, every day. How do I do this without losing the relationships and primary key? Every time I do it, the relationships are broken, primary key is gone. Thanks for...