I need to do a query insert into one table that is also password protected.
How do I insert into a database that is password protected? Both tables are
the same but in different database name. Here is what I have so far.
Set db = OpenDatabase(NKWPath, False, False, ";pwd=Xena")
db.Execute "Insert Into [table1] IN """ & pathDB & """ select * From