Connection to Access DB by means of SQL DTS Package

[jean-claude]

Hi

How is it possible, by means of a DTS Package, to define a connection to an
access dabatase which is protected by a password?
(If i suppress the password on the access DB it works.)

thank you for helping
Jean-Claude

 

[Naresh Nichani MVP]

Hi :

In DTS after selecting Access database file name click "Advanced..." and
then type password in the JET OLDDB: Database password row.

Regards,

Naresh Nichani
Microsoft Access MVP