troubleshooting Question

Microsoft Access Error when trying to export DBF file.

Avatar of kateebebe
kateebebeFlag for United States of America asked on
Microsoft OfficeDatabasesMicrosoft Access
2 Comments1 Solution148 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros