https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Opening-a-Microsoft-Access-database-which-is-passworded/m-p/65156#M879 First i have to confirm whether u are using DI Studio or Base sas<BR /> <BR /> If u want to access through DI Studio first u need to register access file to windows environment. these will do your administrator.<BR /> <BR /> By using source designer u can get it....... Tue, 09 Dec 2008 14:12:02 GMT venkatesh 2008-12-09T14:12:02Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Opening-a-Microsoft-Access-database-which-is-passworded/m-p/65154#M877 Hi<BR /> <BR /> I have an access database which I need to open using SAS. This database has a macro set up that auto-runs queries once the password is entered. They can take up to half an hour. I then need to import the results.<BR /> <BR /> My co-workers have told me it's impossible but i'm sure there must be some way to first open the database (using the x command?), then enter the password automatically, and finally wait till the database has ran before importing.<BR /> <BR /> Does anyone have any ideas how i might go about this? Any help will be greatly appreciated.<BR /> <BR /> Thanks.<BR /> Chris Tue, 09 Dec 2008 11:08:01 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Opening-a-Microsoft-Access-database-which-is-passworded/m-p/65154#M877 deleted_user 2008-12-09T11:08:01Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Opening-a-Microsoft-Access-database-which-is-passworded/m-p/65155#M878 Have you investigated using the LIBNAME statement to access your MDB file? A SAS 9.1.3 DOC link is provided below. Also, the SAS support website <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> may also be useful for reference with DOC and other technical user community papers (by using the SEARCH facility).<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> LIBNAME Statement Syntax for PC Files on Windows <BR /> <A href="http://support.sas.com/onlinedoc/913/getDoc/en/acpcref.hlp/a002107496.htm" target="_blank">http://support.sas.com/onlinedoc/913/getDoc/en/acpcref.hlp/a002107496.htm</A> Tue, 09 Dec 2008 12:55:07 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Opening-a-Microsoft-Access-database-which-is-passworded/m-p/65155#M878 sbb 2008-12-09T12:55:07Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Opening-a-Microsoft-Access-database-which-is-passworded/m-p/65156#M879 First i have to confirm whether u are using DI Studio or Base sas<BR /> <BR /> If u want to access through DI Studio first u need to register access file to windows environment. these will do your administrator.<BR /> <BR /> By using source designer u can get it....... Tue, 09 Dec 2008 14:12:02 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Opening-a-Microsoft-Access-database-which-is-passworded/m-p/65156#M879 venkatesh 2008-12-09T14:12:02Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Opening-a-Microsoft-Access-database-which-is-passworded/m-p/65157#M880 Hi Venkatesh<BR /> <BR /> I am using Base Sas (9.1.3). I've managed to get sas to open the database and wait for 30 mins. the only thing i can't do is automatically enter the password.<BR /> <BR /> Thanks, Tue, 09 Dec 2008 14:53:03 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Opening-a-Microsoft-Access-database-which-is-passworded/m-p/65157#M880 deleted_user 2008-12-09T14:53:03Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Opening-a-Microsoft-Access-database-which-is-passworded/m-p/65158#M881 Are you using ACCESS to PC File Formats or to ODBC?<BR /> <BR /> Please show us your connection statement (whether it's SQL or LIBNAME).<BR /> <BR /> /Linus Wed, 31 Dec 2008 08:28:42 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Opening-a-Microsoft-Access-database-which-is-passworded/m-p/65158#M881 LinusH 2008-12-31T08:28:42Z