Error 3191 in Access

  • Thread starter Thread starter Christopher
  • Start date Start date
C

Christopher

I'm in design view creating a table. When I tried to save the table, I get
the following error message:

Cannot define field more than once. (Error 3191)
You tried to create a table in which more than one field was defined with
the same name. Each field name in a table must be unique.

But all of my field names are different.

Any ideas?
 
It is pretty straight forward. You are trying to create a table with more
than one field with the same name.
 
Yep. However if there isn't two fields named the same, then it's a corruption
issue. Probably needs to run a compact and repair.
 
There aren't two fields with the same name; I will run the compact and
repair. Thank you.
 
Back
Top