Hi,
We developed a process that populates, where we can, an Access Back End database (a govt housing monitoring DB) with data from our housing system, which is on SQL Server 2000. This worked fine last year because the database was not password protected. However, this database is now password protected and even though we have the password we are having problem getting through.
Any advice on connecting from SQL Server 2000 to a password protected Access database would be greatly appreciated.
The plan is to include this user/password in the weekly DTS that uploads data to the Access DB.
Many thanks