Cannot create new table in PGDB named "TIME"

431
2
04-27-2011 09:40 AM
MarkWilson3
New Contributor
I am trying to create a new table in a Personal GDB.  The table name is "TIME".

I get a "Syntax error in FROM clause" when doing so.  Is TIME a reserved word?  Or is this a bug?

I am using the tool in ArcToolbox.  I have tried it with Arc 9.3 and Arc 10.

It works fine when i try to add the same table to a File GDB.

Mark
0 Kudos
2 Replies
JakeSkinner
Esri Esteemed Contributor
Personal Geodatabases are based off of the Microsoft Access framework.  In Access, TIME is a reserved word:

http://office.microsoft.com/en-us/access-help/access-2007-reserved-words-and-symbols-HA010030643.asp...
0 Kudos
MarkWilson3
New Contributor
OK.  Thanks.  Yet another reason why FGDB is preferrable over PGDB.

Mark
0 Kudos