Why Is An Access Query Repeatedly Asking For A Data Source?

[DAPOOLE]

One of my queries is repeatedly asking for a Data Source whenever you execute it despite the user already being logged into the database. Is there a way to disable this?

TIA

 

[DCrake]

What do you mean datasource? can you expand on this please

 

[DAPOOLE]

It opens up the 'Select Data Source' box. I then have to rechoose the user DSN. After that the query returns the results successfully however if you select to run the query again you have to go through the whole process again.

 

[PaulO]

Sounds to me like the Query is running against a linked table in a non-MS Access database environment that requires the connection refreshed?

Have a look at the table and establish what it is ... ?

 

[DAPOOLE]

Sounds to me like the Query is running against a linked table in a non-MS Access database environment that requires the connection refreshed?

Have a look at the table and establish what it is ... ?

Yes that is correct however other queries run fine on the database and don't require constant logging in.

 

[The_Doc_Man]

Usually, when Access asks you for something (and other things that you believe use that same something DON'T ask the question), take a really HARD look at the spelling of what it wants. It is probably spelled wrong. Or the connect string is wrong.

 

[jdraw]

Yes that is correct however other queries run fine on the database and don't require constant logging in.

Is it possible that, on an intermediate screen there is an option to "save" a setting? Sounds like an option to retain a setting has not been ticked.
Just my $.02.