M
Mr 1604
A production MS Access program which was running with Access 2003 & Runtime
2003 and which I converted to Access 2007 works fine with Access, but when I
try to create an executable and run it with Runtime 2007, I get a 3625 error
saying, "The text file specification <file name> does not exist. You cannot
import, export, or link using the specification."
The vb statement that works in Access and fails with Runtime is:
DoCmd.TransferText acImportDelim, How, What, Where
where How = "tSessionLog_MiscEventsSpec"
What = "tSessionLog_MiscEvents"
Where = "C:\Documents and Settings\Roger Meyer\My
Documents\BBContest.Scores\Backup\temp.txt"
Thank you for your help.
2003 and which I converted to Access 2007 works fine with Access, but when I
try to create an executable and run it with Runtime 2007, I get a 3625 error
saying, "The text file specification <file name> does not exist. You cannot
import, export, or link using the specification."
The vb statement that works in Access and fails with Runtime is:
DoCmd.TransferText acImportDelim, How, What, Where
where How = "tSessionLog_MiscEventsSpec"
What = "tSessionLog_MiscEvents"
Where = "C:\Documents and Settings\Roger Meyer\My
Documents\BBContest.Scores\Backup\temp.txt"
Thank you for your help.