ms access insert special characters

[fangorn]

I've got an sql statement i'm trying to execute which looks like this:

INSERT INTO BarcodeDefinition (title, length, value) VALUES ('My Title', 15, '12345[d23]**4445*[e4][e9]')

title is a text field, length is an integer field and value is a text field

On execution, this gives me an insert error.
If I change the statement to this, it works:

INSERT INTO BarcodeDefinition (title, length) VALUES ('VECI Label', 15)

So, is there something special required to insert * and [ or ]?
Does anyone see something stupid I can't see?

Thanks.

[matto]

afaik, in ms access the wildcard which usually is % in sql is the asterisk * ...
I'm not sure how to escape it but I would try * (backslash asterisk) ... or consult google.

hth!