Access 2002 constantly asking for SQL Server password 1

[awhitsel]

I just recently upgraded to Access 2002, and converted most of the applications that I had written.

On one of my applications, I have several tables linked from SQL Server.

Also in this database, are several reports that are dependent on those linked tables to provide the needed data.

My problem is that whenever I try to access the print preview of one of these reports, I am constantly bombarded for the SQL Server password . . . at least 50 or 60 times.

Is there any setting that needs to be set that will force Access 2002 to accept this password one time only?

Thanks.

 

[DJS2]

Have you tried setting up the linked tables again, making sure that the "remember password" box is ticked. It may have "forgotten" this setting in the conversion.