So, you have a query in Access which refers to one or more linked tables
within Access?


"mp80237" wrote in message
...
It never asks for my password in Excel. I think that is the problem is.
When I open the query in Access (which is linked from a table from the SQL
server), I get LoginID and password field. There is not a checkbox field
to
remember password. When I link that query in Excel, I don't get a dialog
box. Only a error. I believe that is where the problem lies. I need a
dialog box to enter the username and password in Excel and have the option
to
remember the password. Is there something in Microsoft Query (what is
grabbing the query from Access) or in Excel that needs to be reset so I am
given a dialog box?

Thanks! MP

"MH" wrote:

This is really an Access question...so here's the Access answer:

When you use linked tables in Access, tick the checkbox that says
something
like "Remember Password" and guess what? You guessed it, Access
remembers
the password so you don't have to supply it.

MH

Access is used to do queries that SQL Server cannot (we have a older
version).

Just out of interest, what version of SQL Server are you running that
Access
is used to do queries it cannot? What type of queries?

"mp80237" wrote in message
...
I have a Access database connected to a SQL server. When I connect to
the
Access database it requests the username and password to the SQL
server.
Access is used to do queries that SQL Server cannot (we have a older
version). I added a link to Excel to create my charts (excel cannot
handle
the full queries Access can). When I link Excel to Access to get my
data,
any query or report that has a table that is linked to the SQL server I
get
the following error: ODBC - connection to "[My SQL SERVER NAMEJ"
failed.
Now, if I use a query for a table that I created that is not linked to
the
SQL Server it links perfectly and I can refresh fine. Any ideas?
I connect by data - import external data - New database query Thanks!