Avatar of kateebebe
kateebebeFlag for United States of America

asked on 

Microsoft Access Error when trying to export DBF file.

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

Microsoft OfficeDatabasesMicrosoft Access

Avatar of undefined
Last Comment
kateebebe
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of kateebebe
kateebebe
Flag of United States of America image

ASKER

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.
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo