http://support.microsoft.com/default...54&Product=ado
HOWTO: Open a Secured Access Database in ADO Through OLE DB

--
Regards,
Tom Ogilvy


"Annelie" wrote in message
...
I used Erlandsens Data Consulting's
(http://www.erlandsendata.no/english/...hp?t=envbamain) DOA and
ADO examples and successfully imported data using either format into an
access table to an unsecured Access 2002 database.
I have a client where I am using Access 2003 which uses security with
logins and all, and when I tried to import into that database I get the
message unable to access the database.
How can I built the security settings into the excel macro?
Any help would be greatly appreciated
Annelie


---
Message posted from http://www.ExcelForum.com/