External Data refreshment
 

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

External Data refreshment
 

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" wrote in message
...
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

External Data refreshment
 

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

"Shane Devenshire" ha scritto nel messaggio
...
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" wrote in message
...
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