MS Access Escape Character

[ljprivara]

I am trying to create a string that contains the path of a file. The path sequence is H:\CIG-shared\technology\. . .

Access returns error message saying unable to locate H:\CIG. I tried putting a '\' before the -, [] around the -, double and single quotes around the -, to no avail. Any ideas?

Also, is the file name case sensitive?

 

[CPUburn]

hi,
I had about the same problem a while ago.. have you tried to enclose the whole string in quotes? (double or single) if yes, could you post a piece of the code you use for it, it's easier to locate the problem that way

CPU-burn

 

[ljprivara]

I should have mentioned that I also used double, then single quotes around the entire string. It was still rejected.