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
Solved! Go to Solution.
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?
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 ;)
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.
I can't use this solution because I am on a 64-bit machine with 64-bit office. Is there another solution?
@byarsmc79 I believe there is also a 64-bit version of the Microsoft Access Database Engine 2010 Redistributable file.