Export - with password more than one table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
i use this code:
DoCmd.TransferDatabase acExport, "Microsoft Access", "\\server\pcg\pcg.mdb",
acTable, "Kunder", "Kunder"

1. Can i in this code have a password to \\server\pcg\pcg.mdb so i don't get
this box where i shall write the password?

2. Can i in this code take more than one table or shall i write a new Docmd
for another table, because if i can't send the password in the code then i
shall write the password every time i have Docmd, so if i have 5 table then i
get the loginbox 5 times, not so funny

Regards
Alvin
 
Back
Top