D
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.
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.