Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a Query in Excel based on an Access Qry...
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? -- Glenda |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a Query in Excel based on an Access Qry...
Glenda Wrote: 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? -- Glenda 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 | +-------------------------------------------------------------------+ -- Osmar Mateus ------------------------------------------------------------------------ Osmar Mateus's Profile: http://www.excelforum.com/member.php...o&userid=30938 View this thread: http://www.excelforum.com/showthread...hreadid=511972 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel to Access... | New Users to Excel | |||
Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
Error message in Excel after exporting Access query to Excel | Excel Discussion (Misc queries) | |||
Easiest Way to have access functionality in Excel or vice-versa? | Excel Worksheet Functions | |||
Excel and Access talking | Excel Discussion (Misc queries) |