Error 3191 in Access

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?
 
K

Klatuu

It is pretty straight forward. You are trying to create a table with more
than one field with the same name.
 
J

Jerry Whittle

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

Jerry Whittle

When you live in Illinois, corruption is the first thing that comes to
mind......
 
C

Christopher

There aren't two fields with the same name; I will run the compact and
repair. Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access message "cannot define field more than once" 9
sqlite-odbc write conflict 2
Cannot define field more than once. (Error 3191) after shuffling o 1
Visio: copy text of a master shape to User-define Cells (Variable) 0
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Autonumber field in Excel that behaves the same as Access 0
Error 3191 Cannot Define Field Name More Than Once 1
Active Content in this file is blocked issue 1

Top