Thread: Export Excel data to Access Security problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Annelie[_3_] Annelie[_3_] is offline
external usenet poster
  
Posts: 1
Default Export Excel data to Access Security problem
I used Erlandsens Data Consulting'
(http://www.erlandsendata.no/english/...hp?t=envbamain) DOA an
ADO examples and successfully imported data using either format into a
access table to an unsecured Access 2002 database.
I have a client where I am using Access 2003 which uses security wit
logins and all, and when I tried to import into that database I get th
message unable to access the database.
How can I built the security settings into the excel macro?
Any help would be greatly appreciated
Anneli

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

Reply With QuoteReply With Quote