SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in Connecting to MS Access Database      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic Connecting to MS Access Database Author Message cldcp00 Joined: 24 Apr 2015 Posts: 1 Country: United Kingdom Connecting to MS Access Database Apologizes for this very simple question. I am new to have databases and am trying to teach myself i have read the user guide and still cannot get SQL assistant to connect to MS Access I have a Access database called CPMG Clarity Database Ver 3.mdb and just want to connect to it and create some SQL quires Any help will be much appreciated Regards Desmond Fri Apr 24, 2015 6:53 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7849 Please right-click SQL Assistant's icon in the system tray, and in the menu select SQL Editor. When SQL Editor opens up you will be presented with a Connect dialog. Choose MS Access from the Database Type drop-down. The dialog will change. Usee the [...] to select your CPMG Clarity Database Ver 3.mdb file. click Connect. That should be it. If you get any errors, please provide the complete error text. Wed May 06, 2015 12:39 am Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.