I have a query functional and it uses a userdsn. My problem is that the query in access continuously asks for a dsn validatioin everytime I do something to the results. if I try to filter... it prompts. if I try to sort... it prompts.
how can I set this up so that everything will continuously run in this access environment without always asking me for credentials.
the dsn is using a sql account that has read only access.
everything works great except for this