MS Access .accdb New Table With Blank Dates Issue

[TR]

I'm updating a MS Access table from .mdb (2000-2003 format) to .accdb (2007-2016 format) and am having an error occur when moving the date fields.

Here is my example table with two attributes I'm loading into a new Access table:

Recordset1 = '1' (long integer) and Date1 = '11/20/2017' (Date)

Two outputs: Create new table 'tblDateTest' works fine in the AccessDB.mdb format but fails in the AccessDB.accdb format.

Error: Output Data (5): DataWrap2OleDb::SendBatch: Microsoft Access Database Engine: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Insert into `tblDateTests`(`RecordID`,`Date1`) Values (?,?)

Thanks in advance,

Todd

[MarqueeCrew]

Is it possible to read Date1 as a STRING and output it as a STRING instead of a date?

[TR]

Thanks @MarqueeCrew for the reply, I can read it as a string and output it as a string however I need to store the field as a Date in Access. Now I could probably work on the Access side of things and convert it from a string to a date, however I was hoping to avoid that. Are you able to replicate this as well?

[MarqueeCrew]

Sorry @TR, but I'm allergic to Access.  I don't have it.  I buried it with DBase III and DBase IV.

[TR]

Hahaha, I don't blame you. It's painful for me to even create and update an Access database but it's part of a business function ;)

[TR · Accepted solution]

I've uploaded a sample workflow to further explain this seemingly simple process. Once the 32-bit MS Access database driver (download AccessDatabaseEngine.exe) was installed and the 64-bit version uninstalled this issue was resolved.

[byarsmc79]

I can't use this solution because I am on a 64-bit machine with 64-bit office.  Is there another solution?

[TR]

@byarsmc79 I believe there is also a 64-bit version of the Microsoft Access Database Engine 2010 Redistributable file.