External Data refreshment

[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

 

[Shane Devenshire]

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

 

[eggpap]

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