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
Cannot define field more than once. (Error 3191) after shuffling o 1
Error 3191 Cannot Define Field Name More Than Once 1
Error 3191 on Export (Cannot Define Field More Than Once) 0
exporting to a dbf file 3
Access Access - Is it possible to repeat fields in a form? 1
Can't create a report from my query in Access 1
Designing Access Table in Excel >> Copying to Access Desgign 4

Top