Creating a Query in Excel based on an Access Qry...

G

Glenda

I have an Access Qry based on an ODBC Database that is password protected.
Is that why I get an error when I try to use an Excel Query to the Access
Query? Is there any way around this?
 
O

Osmar Mateus

Glenda said:
I have an Access Qry based on an ODBC Database that is password
protected.
Is that why I get an error when I try to use an Excel Query to the
Access
Query? Is there any way around this?
Click to expand...

Glenda

I hope I am understanding what you want: you need to indicate "save
password" in the Data Range Properties (see attachment). The first time
you access the data base you will have to inform the password.

Osmar Mateus


+-------------------------------------------------------------------+
|Filename: Example.pdf |
|Download: http://www.excelforum.com/attachment.php?postid=4514 |
+-------------------------------------------------------------------+
 
Top