B
brupp24_6
Forgive me if this is in the wrong board.. wasnt sure where to go.
I have an excel (2003) spread sheet using MSQuery to import from an access
db (access 2000). Importing to excel is unfortunately necessary to run some
statistical information. Currently its set up to refresh on open, then
delete external values. I prefer this due to the number of records (and a
very slow network drive).
Here's the problem. The query refreshed fine prior to setting a pw on the
access db. I checked the "save password" box under query def on the external
data range properties... But everytime I attempt to run the query I get the
"incorrect pw" error.
Please help.
I have an excel (2003) spread sheet using MSQuery to import from an access
db (access 2000). Importing to excel is unfortunately necessary to run some
statistical information. Currently its set up to refresh on open, then
delete external values. I prefer this due to the number of records (and a
very slow network drive).
Here's the problem. The query refreshed fine prior to setting a pw on the
access db. I checked the "save password" box under query def on the external
data range properties... But everytime I attempt to run the query I get the
"incorrect pw" error.
Please help.