Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Access connection

Author  Topic 

rookie_sql
Constraint Violating Yak Guru

443 Posts

Posted - 2006-08-31 : 04:42:30
Hi i've a DTS package that uses a access databse to transfer data between SQL and Access, but when i set a password on my access database my DTS package failed so i'd like to know how i get around this issues do i need to write code in my DTS package and embed my access password into it ?
   

- Advertisement -