MS Access .accdb New Table With Blank Dates Issue

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

Output

Date Time

Accepted answers

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.

Output Dates to Access 2016 Format.yxzp

All comments

MarqueeCrew

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

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?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280