Microsoft Access Error when trying to export DBF file.

kateebebe
kateebebe used Ask the Experts™
on
We just upgraded to Office 2013 and I get the following error when I try to export as a DBF file.

"Trouble: Error 2507: The dBase IV type isn't an installed database type or doesn't support he operation you chose.

Option Compare Database
Option Explicit

Function Transfer(vPath)
'1st location file
On Error GoTo TransferError
If IsNull(vPath) Then
    MsgBox "Please enter a path first"
Else
    DoCmd.TransferDatabase acExport, "dBase IV", vPath, acTable, "Location File", "Loc.dbf"
    DoCmd.Echo True, "Loc.dbf Export OK"
    DoCmd.TransferDatabase acExport, "dBase IV", vPath, acTable, "Account File", "Acc.dbf"
    DoCmd.Echo True, "Acc.dbf Export OK"
    DoCmd.TransferDatabase acExport, "dBase IV", vPath, acTable, "Reinsurance File", "Re.dbf"
    DoCmd.Echo True, "Re.dbf Export OK"
    MsgBox "All Exports Ok"
End If
GoTo GracefulExit
TransferError:
If Err = 3010 Then
    MsgBox "File already exists.  Please delete old .dbf files first."
Else
MsgBox "Trouble: " & "Error " & Err & ": " & Error$
End If
GracefulExit:
End Function

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
dBase support was removed in Access 2013, but came back in Access 2016.

So, upgrade one more level.

Author

Commented:
ugh.  Okay, thanks for your help.  Shaking my head.  Although its 2018 and my company is just now upgrading to 2013, so I'll just have to figure something else out.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial