topic Cannot create new table in PGDB named "TIME" in Data Management Questions

Cannot create new table in PGDB named "TIME"

MarkWilson3 — Wed, 27 Apr 2011 16:40:11 GMT

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

Re: Cannot create new table in PGDB named "TIME"

JakeSkinner — Wed, 27 Apr 2011 17:09:57 GMT

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

Re: Cannot create new table in PGDB named "TIME"

MarkWilson3 — Wed, 27 Apr 2011 17:18:56 GMT

OK. Thanks. Yet another reason why FGDB is preferrable over PGDB.

Mark