Non-alphanumeric character in field name causes error

[masonf]

I am using a Access Database with ASP to store information collected on a web site. Due to constraints I must follow, two fields have an ampersand (&) in the field name, and when I reference the field in code, such as oRS.Fields("W&T").Value = True, I get the following error:

Microsoft Cursor Engine error '80040e21'

Multiple-step operation generated errors. Check each status value.

If I comment those fields out, the error does not occur. It apparently has something to do with the non-alphanumeric character in the name, but I will not be able to change that. Is there some easy way to get around this problem?

 

[KenReay]

Hi

you could reference the field by position, a bit non self documenting however

oRS.Fields(1).Value = True

you need to get the correct value for 1 however

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK