reserved word in OleDb for Access???

[Darryn Ross]

Hi,

I was wondering how you might get a list of the reserved words in oledb for
Access so i don't run into anymore issues with my column names in my tables.

thankz

Darryn

 

[Ken Snell]

Not sure if this is exactly what you're seeking, but it may get you started.

See KB article number 286335 for more info:

ACC2002: Reserved Words in Microsoft Access
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335

 

[Van T. Dinh]

There are different Collections, Objects, Properties, Methods and Events so
there are numerous reserved words in ADO and I don't even know them all.

You can check the ADO Help and you should find reserved words. However,
they are not listed in one covenient place.

However, I usually use a naming technique which seem to work quite well. I
notice that most reserved words, inbuilt object names, properties, etc...
are one or more words spelled out *in full*. Using that, my Field names are
usually the concatenation of 2 or more abbreviated words, says, the first 4
characters of each word. Some examples are:

CustName (never "Name")
ProdCode
StartDate (never "Date")

With this technique, I seem to avoid the reserved words in Access / VBA /
DAO / ADO so far ...