CODEWITHSUNDEEP
ms-accessexceladovba
mrbillbenson
mrbillbenson

Reputation: 87

ADO - future Path for Access databases

Will I be able to create access database back-ends (on machines without MS Access installed) using ADO and DDL in an Excel 2010 or 2013 (32-bit) on a Win-8 or 8.1 system?

There is a lot behind this question that I am not writing here, fueling my anxiety - having to do with JET support being dropped, uncertainty about where ACE really resides (in Windows? / in Office? / in Access (only) libraries) - etc...

I want to make sure that using 32-bit Excel and a few project references, I can create back-ends on the fly and store and retrieve data.

Thanks.

Upvotes: 1

Views: 158

Answers (2)

Yawar
Yawar

Reputation: 11627

There is an Access database engine redistributable that is intended to give you a migration path off of Access: http://www.microsoft.com/en-us/download/details.aspx?id=13255

But, it looks like you may be able to use it as an actual database engine if you want, even though it's not recommended.

Upvotes: 0

Gord Thompson
Gord Thompson

Reputation: 123779

The older "Jet" database engine is still part of a standard Windows install, including Windows 8.1. It is only available to 32-bit applications because there is no 64-bit version of Jet, and it can only work with .mdb files (not .accdb files). Yes, Jet has been officially deprecated, but for now it is still a viable option in the 32-bit world.

Upvotes: 1

Related Questions