A
alr
Guest
Hi All,
When I run the code containing the line below in (Access 03) my procedure and step through each line it runs perfectly.
DoCmd.TransferDatabase transfertype:=acExport, databasetype:="Microsoft Access", _
databasename:=strDB & strWkOrd & strCaseCode & ".mdb", _
objecttype:=acTable, SOURCE:="WkDt", _
Destination:="WkDt", structureonly:=False
When I take out the break point and let it run from a button I get the following error message.
"Cannot open database 'U:\tst1\99999test1.mdb'. It may not be a database that your application recognizes, or the file may be corrupt."
The database named is the destination for the export. If I try the export manually to the same file, it works every time. Any idea what could be going on here?
Thanks,
alr
When I run the code containing the line below in (Access 03) my procedure and step through each line it runs perfectly.
DoCmd.TransferDatabase transfertype:=acExport, databasetype:="Microsoft Access", _
databasename:=strDB & strWkOrd & strCaseCode & ".mdb", _
objecttype:=acTable, SOURCE:="WkDt", _
Destination:="WkDt", structureonly:=False
When I take out the break point and let it run from a button I get the following error message.
"Cannot open database 'U:\tst1\99999test1.mdb'. It may not be a database that your application recognizes, or the file may be corrupt."
The database named is the destination for the export. If I try the export manually to the same file, it works every time. Any idea what could be going on here?
Thanks,
alr