SQL Server Login prompt on some reports

[lerosey]

Hello. The Access db has several linked tables to SQLServer. Does anyone
know why some reports prompt for the SQLServer login and some don't? The SQL
Server login prompt can appear on Run mode and sometimes Design mode. But
not on all reports.

Thanks for your help.

 

[Jeff Boyce]

I'll hazard a guess that when the tables underlying those reports were
linked, the checkbox for "remember this password" was NOT checked.

Regards

Jeff Boyce
Microsoft Office/Access MVP