Hello everyone,

I have an access database ("Inspectors") that I would like to export to .dbf ("Inspectors.dbf") using the TransferDatabase action. The main table I want to transfer is called "SFTable".

I am using the following code:

DoCmd.TransferDatabase acExport, "dBase IV", "C:\Inspectors.mdb", acReport, "SFTable", "Inspectors.dbf"

When I run the code, a message box appears saying that "C:\inspectors.mdb" is not a valid link. The database is there and it is not corrupted. Am I coding it wrong?

Thanks for your help.