reserved word in OleDb for Access???

  • Thread starter Thread starter Darryn Ross
  • Start date Start date
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
 
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 ...
 
Back
Top