ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Access Error Message - DataWrap2OleDb

lynnaberry
7 - Meteor

I have been dumping data in Access for several years using the same database. I have not changed anything, but today I tried to run my workflow like usual and I got the following error:

 

Error: Output Data (64): DataWrap2OleDb::SendBatch: Microsoft Access Database Engine: Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.\3049 = -78972086
Insert into `Possible Expungements`(`county_jid`,`firstname`,`lastname`,`DOB`,`Current_Age`,`Ethnicity`,`Juvenile_Status`,`JOTN`,`Case_Number`,`Docket#`,`Docket_Number`,`Referral_Date`,`Case_Closed_Date`,`Length_of_Time_Opened`,`Length_of_Time_Closed`,`Expunged_Date`,`PO`,`PO_Full_Name`,`CASE_CLOSED`,`Active`) Values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

 

I searched the forum and tried doing all of the suggestions previously provided, but still getting the error. The date fiel is listed as VW_string. I tried switching to a string, but still geting the error. None of the integers are listed at Int64, so I'm not sure what to do at this point. All of the data I had in the tables was wiped due to the error.

3 REPLIES 3
ArtApa
Alteryx
Alteryx

Hi @lynnaberry - Can you please check your MS Access DB driver version? If it was updated, this may have caused your problem. 

 

Alteryx supports 2010: https://www.microsoft.com/en-au/download/details.aspx?id=13255 

lynnaberry
7 - Meteor

Hello! Yes, I have it installed. I just uninstalled and reinstalled it and got the same error.

lynnaberry
7 - Meteor

Error message still not resolved

Labels
Top Solution Authors