Discussion Locked
MS ACCESS Error 3304-Invalid Path
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Using VBA - DoCmd.transfertext, the file name (ex. "C:\My Documents\Oops\transfer.txt" will bomb out.Even if I use "C:\'My Documents'\...". it gives the same error. It definitely is the space that is causing the problem. I have separated the path and combined it programmatically, but the same results. I am using OFF XP and Win XP professional. My_Documents is not a viable solution. I've tried """"..."""" and other combo's that have worked in the past in other areas, but this is the first problem I've encountered in transfertext of this sort.