"Not a valid password" message

[!pro-progammer:)]

When I coding "DoCMD.RunSQL 'Select <Some Field> FROM <A Table> IN <Another
Database>' " but that database is password protected, I always get "Not a
valid password" message.

Could anyone help me on this?

Thanks.

 

[mscertified]

Why don't you link to the table via the Linked Table manager? Then you will
specify the password at link time.

-Dorian

 

[Klatuu]

Here is another way to do this programmatically:

Dim tdf As TableDef

With CurrentDb
Set tdf = .CreateTableDef("CDSchedule", dbAttachSavePWD,
"tblSchedule", _
";Database=" & strPath & ";Pwd=downwind")
.TableDefs.Append tdf
.Execute ("qryUpdateCDMD"), dbFailOnError
End With

DoCmd.DeleteObject acTable, "CDSchedule"
Set tdf = Nothing

strPath will be the path and name of the database

 

[!pro-progammer:)]

It seems that there's no simple way to run the SQL command to get data from
another password-protected database and then insert them into current
database.

All that I want is just run an SQL command.

Thank you anyway.

 

[Klatuu]

What is so hard about what I posted?
It does exactly what you are wanting to do.