attachement

[fucell26]

hi access gurus!



im having a problem with my database in attachement field. im trying to attached a PDF file with has a name "O&M procedure" but when im trying to attach it, access give me error

"the file name contains one more invalid characters" which is i think the "&" character. just want to ask if there is a way to allowed this. i mean access will ignore the file name specially those characters.

please help.


thanks

[pbaldy]

From help:

Names cannot contain the following characters: question marks (?), quotation marks ("), forward or backward slashes (/ \), opening or closing brackets (< >), asterisks (*), vertical bars or pipes (|), colons (, or paragraph marks (¶).

which doesn't mention the &, but would imply there is no way around the restriction if you were trying one of those.

[ItsMe]

I think Windows is OK with the ampersands ever since the NTFS file format. It is VBA that does not like it. Perhaps the Replace() function to change out & with _ or something.

I suppose you could do a lot of fancy foot work to display attachment names as they were originally. If we are talking about attachment fields, why do you need to use them? Why not just store the files on a server and their paths in a plain Jane Text Field.

[fucell26]

sorrry for late reply. but you are correct i just use hyperlink to attached file using form.

thanks to all who reply.