External Data refreshment

  • Thread starter Thread starter eggpap
  • Start date Start date
E

eggpap

Hello,

I have some tables of a worksheet linked to one Access database I refresh at
the workbook opening.
The database source is not protected, but I'ld like it could be.
I've tried to set a database password, but at the workbook opening it asks
the database password for each query it has to refresh.
I have also set the password argument in the query definition of each table,
but nothing
has changed. Excel version 2003.

Any help?
Emiliano
 
Hi,

1. Select the Excel query range - this should display the External Data
toolbar
2. Click Data Range Properties
3. Check Save password

Cheers,
Shane Devenshire
Microsoft Excel MVP
 
Hi,
i've set the Save Password option for each range linked to a query,
the query connection's data become modified with the "Database Password="
set to the Access Database password, but restarting the workbook
it asks again the password for each range.

Emiliano
 
Back
Top