reserved word in OleDb for Access???

D

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
 
V

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 ...
 
Top