'sa' Passwording for Linked tables

[Guest]

I created an mdb with tables linked in via ODBC. On a couple of the tables I
forgot to save the 'sa' password when linking. After completely developing a
report with query, form, etc, I noticed my mistake in that users are prompted
for the password when trying to print my report. I proceeded to delete the
table links and relink them with the 'sa' password saved this time. But it
seems that my query that references those tables still retains the former
security settings, and still prompts for the password! Is there any way to
"refresh" those security settings without rebuilding my query from scratch ??

 

[david epsom dot com dot au]

"refresh" those security settings without rebuilding my query from scratch

??

compact.

If that fails, delete all links, then compact, then relink.

So far, that has worked for us, I'll be interested to hear
if you still have problems

(david)

 

[Van T. Dinh]

* Are these Tables linked via a DSN? If they are,you can set the LogInID /
password on the DSN rather than on individual Tables.

* The Query is not a Pass-Through Query by any chance? If it is, it doesn't
use the linked Tables and you may have to reset the Connection String for
the Pass-Through Query.