i'm assuming you're using linked tables via odbc here. if that's the
case make sure the password is stored in the connection string for the
table. prob the easiest way to do this is delete the linked tables
and relink them. be sure the "save password" checkbox is checked in
the "link tables" dialog. if you don't want to relink open the table
in design view and goto view->properties to view the connection
string.


> I have a user that is running a query that is being split into 3
> batches by SQL Server behind the scenes and is requiring the user to
> provide his password 3 times - he claims it used to only want 1
> password he's changed nothing. This is using SQL db auth and the
> query is a left outer join in Access 97, if it means anything.
>
> TIA