Bill Benson
bensonforums at gmail.com
Thu Apr 3 17:33:20 CDT 2014
I will try this again, I don't know if my way of asking these matters be explained to me better is not coming across, or no one has looked deeply into these concerns? I don't have windows 8 but didn't want to keep investing time in ADO based solutions that will work only so long as (1) Jet is part of the OS or (2) MS Access is installed on a user's machine. ---------- Forwarded message ---------- From: "Bill Benson" <bensonforums at gmail.com> Date: Apr 3, 2014 3:41 PM Subject: MDAC and 64 bit os (win 8) and ACE To: "Microsoft Excel Developers List" <EXCEL-L at peach.ease.lsoft.com> Cc: Got used to ADO and using ADO catalog to create a mdb or accdb using Jet oledb. This meant I could also use JRO to compact it. In trying to prepare for Win 8 os clients, trying to learn what will no longer be native to win 8 plus 32bit office (withOUT Access installed). Have in mind Jet is not in Win 8, right? So, if not, I assume no JRO either? Assume target user machine WILL NOT have Access installed but will have Office (excel) v 12 and up. Can I be assured ADODB and ADOX will be present due to MDAC being part of win 7 and 8? So that references to ADO 6.x and ADO Ext x.x for DDL and Security will allow code to create database using ACE provider, and create, manipulate table objects and columns, indexes, keys, constraints... (fk relationships witg data integrity rules) ... whatnot? Will I be able to compact? Essentially I thought there might be some reason I cannot create Excel apps that build their own backends on the fly under win 8, but I am starting to doubt there will be any problems? Even though ACE has "Access" in the name is this present in Office 12+ without Access installed? Please help alleviate my confusion?