Make Table Query Question

[worldwidewall]

I have a make table query that I want to use to overwrite an existing table. But the existing table has relationships that I don't want to delete. I want the old table to contain the data from the results of the make table query without deleteing the relationships.

How do I do this?

Thanks

Dave

[June7]

Is the table structure unchanged? Instead of overwriting table, you could delete all records and then insert the new set of records.

If you are changing table structure, then don't think can use MakeTable and overwrite without removing relationships. An alternative might be to use VBA and ALTER TABLE sql action to restructure the table. Then delete records and insert new records. Another alternative might be VBA code to modify the table properties with TableDefs (remove the relationships, overwrite table, reset relationships). As you can see, gets complicated.

[worldwidewall]

The table structure remains completely unchanged, just new data. How could I remove all the old data and add the new in vba?

Thanks

[June7]

Run DELETE and INSERT actions. You can either build and save queries with Access query designer and run them or construct the SQL statement in VBA.

This will execute an Access saved query
DoCmd.OpenQuery "query name"

This will execute an SQL statement:
CurrentDb.Execute "DELETE FROM tablename"
CurrentDb.Execute "INSERT INTO ... SELECT ..."

Review http://msdn.microsoft.com/en-us/library/ms188263.aspx for specifics on the INSERT SELECT statement.

[worldwidewall]

Thanks

I will give it a go.