SELECT brands.* INTO brands IN "+backupFileName+" FROM brands This is supposed to copy all the records in the brands table into another table also called brands but in a different database . The database called backupFileName Now the problem is that the backupFileName is password protected, so I can't insert anything in it . it's an access database I am using ADO any solution? how can I specifiy the password?
Here is an MS article on using ado to insert into a protected jet db. It works as long as you know the password... MS article