SQL links.

[j_Southern]

I have four tables on a worksheet each loaded by an ODBC link originated using MSQuery.

The code I use follows

Please Login or Register  to view this content.

This works for the first two tables, but not the others.
If I rightclick the designated cell (and I am sure the offsets are right) then I can refresh all four tables.
I think my code must be wrong but I can't see where.
Can any one help?
John

[xlnitwit]

If you comment out the On Error Resume Next line, what happens?

[j_Southern]

xlnitwit,
Thanks for your interest.
What happens is that on some queries, but not all, I get a message "Authorisation Error".
It is true that when I perform a "Right Click Refresh" manually, I am asked for the SQL password. This is why I have the line Application.DisplayAlerts = False as I don't want my users to have enter a password four times in a row.
All the queries are fundamentally the same, selecting data from a combination of up to three tables in a SQL database. So it is difficult to understand why they react differently to the same code.
John

[j_Southern]

Is it possible to code in a password if one is needed to gain access by MSQuery to a SQL or other Data Base?
John

[xlnitwit]

It is possible when setting up the query to save the password with it, which is what I assume has been done with the queries that do not prompt you.