MS Query won't open MS Access database for import to Excel

[af390]

I am trying to import MS Access data into a very complicated multi sheet Excel spreadsheet. The data is back end protected by a workgroup secrity login protocal that MS Query is not able to process.

Any suggestions on how to program MS Query to accept the login protocal.

This is the security login script:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "\\... path..\name_BE.mdb" /WRKGRP "\\...path...\Secured.mdw"

Thanks much!!!!

 

[xlbo]

Not sure you can to be honest - MS Query is just a simple GUI that creates SQL and processes it via ODBC. If you could bypass the security in Access via this, it'd kinda destroy the point of the security....

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[af390]

That's kinda what I thought. Just wanted to toss it out there and see if someone had an easier solution. I've inherited someone else's program......sigh.

Thanks

 

[xlbo]

I am by no means an expert on Access although I know a fair amount about MS Query - you may want to ask this in one of the Access specific fora - there are about 4 or 5 I think and can be found using the forum locator

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question