Access to SQL Server via DTS - getting an error

[rockyroad]

Hello

I am importing an Access database into SQL Server via
DTS. I am using the Wizard. I am able to successfully connect to both my ODBC datasource on my local machine (Access) as well as the OLE DB datasource, the SQL Server. I have been able to successfully import tables only one at a time using the "Use a Query" option. However, when I have attempted to use the "copy tables and views" option, I choose the tables I want to import, and then click Next, I get the following error:

"Error Source: Microsoft OLE DB Provider for ODBC Drivers.
Error Description: Microsoft Access Driver - Not a valid password. Context: Error calling OpenRowset on the provider."

I have entered the correct passwords for both databases, otherwise how would I have been able to import using the "use a query" option which runs without a hitch.

Any ideas on what might be happening here?

Thanks RR