Hi - I have a macro that is attached to a command button on my form that runs a step that executes (run code) a function called ExportData() a colleague created a long while ago. It exports the main database table to a txt delimited file that feeds a process to our SQL tables. Mind you this has been running for over a year without any issues.
I recently added data elements to the table and removed one data element and now when I click on the button to open the form I am receiving this message:
Microsoft Visual Basic dialog box displays with Run-time error '3438'
"The data being exported does not match the format described in the Schema.ini file.
My VBA module looks like this:
Public Function ExportData()
DoCmd.TransferText acExportDelim, "TblIOSDisputes Export Specification", "tblIOS_Disputes", "\\njfilecluster.cbhnp.org\public\Clinical Department\Clinical Review Database\IOSBackUp\IOSDisputeBackUp_" & Format(Date, "yyyy-mm-dd") & ".txt", True
End Function
When I skip this step in the macro the form displays correctly but this step is important to feeding a process for updating the SQL tables. The changes made to the table need to be defined to this schema.ini file but where do I find it? Is it a hidden file in the folder?
Thank you for your help.
I recently added data elements to the table and removed one data element and now when I click on the button to open the form I am receiving this message:
Microsoft Visual Basic dialog box displays with Run-time error '3438'
"The data being exported does not match the format described in the Schema.ini file.
My VBA module looks like this:
Public Function ExportData()
DoCmd.TransferText acExportDelim, "TblIOSDisputes Export Specification", "tblIOS_Disputes", "\\njfilecluster.cbhnp.org\public\Clinical Department\Clinical Review Database\IOSBackUp\IOSDisputeBackUp_" & Format(Date, "yyyy-mm-dd") & ".txt", True
End Function
When I skip this step in the macro the form displays correctly but this step is important to feeding a process for updating the SQL tables. The changes made to the table need to be defined to this schema.ini file but where do I find it? Is it a hidden file in the folder?
Thank you for your help.