Exprting to Database with Password Protection

[Dkline]

I am starting in my "source' database and exporting a number of tables to
the "target" database. The "target" database is passwor protected.

When anyone run this they have to enter the passord 19 times - one for each
export.

I am using:
DoCmd.TransferDatabase acExport, "Microsoft Access", PathToSource, acTable,
NameOfQuery, NameOfTable, False, strPWD

Do I need to reverse this? Open the "target" database and import from the
"source" database?

We're trying to do this in an AutoExec macro which - up until the time the
SVP applied the password to the "target " database - worked perfectly.

 

[jeffc]

Any good?

I'm trying to do exactly the same thing, did you find a way?

I've even tried to remove the password from code, but I can only change the password not remove it.

Cheers

Jeff