In Microsoft Access 2003 and Visual Basic 6 I'm trying to copy a table to another access database that is password protected like this...
Select * INTO table2 IN 'database2.mdb' [;Password=TestPass] From table1
It fails with "Not a valid password"
Does the Select INTO format not accept the password with the mdb, and the password has to be in a connection string? If not, how do you reference a different connection string/database?
thanks