What are some reserved names for Access?

[ThatThatGuy]

I was working in a online inventory application for my client....
I had a Access database......in which there was a few tables.....

In one of my tables i had columns like PurchaseDate, ExpiryDate, ItemName, ItemCode, ItemBarCode, Size, Shape, Make, Color, Qty...etc
I passed a simple insert query to insert values to these fields....

Every time i click on Submit button i used to get error message as Syntax Error in insert into statement...

I sat for 2 hrs....try fixing it...it seemed that there's nothing wrong with the insert statement....
Database connection was perfect...
After 1 hr of debugging in all sorts of ways ....the error was the same...

Now The table had 21 columns.....and i wrote insert statements for each column one by one....
and came to a conclusion that insert statement works absolutely fone on other columns..except the Size column...Now how was it happening ..i don't know....
Then i changed the column name in the database to ISize....and Wola everything was fine.....

Now i understood that Size is a reserved word and i can't use it...
other reserved words i found out are Name, Level...

And Lets see how much you can find......@!!@$#%#

[gits]

to avoid such issues it is good practice to create and use a naming-convention while building the database. you might use a prefix like 'tbl' for tables, 'fld' for fields and similar ... so your tables would have names like:

tblItems
tblWhatever
tblSize
tblDate

while the fields for tblItems could be:

fldFoo
fldBar
fldFooBar
fldDate
fldSize

[ThatThatGuy]

That's purely correct on your part.......I'm too a big convention fan....
But, my employer or my boss is a primitive FOXPRO programmer....
Doesn't know RDBMS....doesn't know OOPS....wants everything simple enough....to understand...
That's the thing???

My fate.....

[gits]

even a boss should/could be convinced to use a good convention ... especially when it helps AND is easy to understand ... tbl-, fld-prefixes for example doesn't make things more complicated nor does it make 'names' less readable ... btw. i think you got the point :)

kind regards