overwrite a table without confirm to an external MDB
Posted on 2004-08-05
I want to export, with a macro or code, a few tables or make table queries to an external MDB.
If I do a make table query or macro CopyObject or code DoCmd.CopyObject to make or copy a table to external mdb and the table exists in the external mdb I get a 'already exists, overwrite?' confirmation. I don't want to see these confirmation.
Is there a way to override this? I can delete a table using code within the current db without confirmation, in order to then recreate it in current db so don't get this message. But can't seem to do same in an external db.