Union Query with 2 MDBs that locked with database password

[Mohsen Darrehshiri]

Hello

I Have a problem. I have 2 database that locked
with "Database Password". Then I want create one Union
query from these MDBs. But I give a message "Not a Valid
Password" in Access2000.

DB1 DB2
Siaq1382 Siaq1383

First I connect to Siaq1383.

Then Write

{
Select SM.No, SM.Date, SM.PersonID From SM Union Select
SM.No, SM.Date, SM.PersonID From SM In 'Siaq1382'[;PWD=XXX]
}
but not answered.

Please help me that message appear for What?

Sincerely yours,
Mohsen Darrehshiri

 

[Gary Walter]

Hi Moshen,

If full path to Siaq1382.mdb were

C:\Siaq1382.mdb

and pwd were "fred"

Select
SM.No,
SM.Date,
SM.PersonID
FROM
SM IN '' [MS Access;PWD=fred;DATABASE=C:\Siaq1382]

That is 2 single quotes, not one double quote.

Good luck,

Gary Walter