Export - with password more than one table

[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

 

[Alex Dybenko]

Hi,
if you have a password to database - then you can try this:
http://alexdyb.blogspot.com/2006/04/how-to-export-objects-to-secured.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

Thanks alex Its working

best regards alvin

Hi,
if you have a password to database - then you can try this:
http://alexdyb.blogspot.com/2006/04/how-to-export-objects-to-secured.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com