var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: TransferDatabase help
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.
If "SFTable" a tabel or report. The code you entered says it is a report. If it is a table that could be what is cuasing your problem.
It's a table. I tried changing the code to acTable instead of acReport and I got the same error. It reads:
Run-time error '3044'
"C:\Inspectors.mdb is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides."
Any ideas what this is all about?
Thanks for the help!