|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 14th, 2009, 08:07 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Error 3191 in Access
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? 
|
|
#2
July 14th, 2009, 08:55 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Error 3191 in Access
It is pretty straight forward. You are trying to create a table with more
than one field with the same name. -- Dave Hargis, Microsoft Access MVP "Christopher" wrote: 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?
|
|
#3
July 14th, 2009, 09:18 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Error 3191 in Access
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. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Klatuu" wrote: It is pretty straight forward. You are trying to create a table with more than one field with the same name. -- Dave Hargis, Microsoft Access MVP "Christopher" wrote: 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?
|
|
#4
July 14th, 2009, 09:26 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Error 3191 in Access
There's a possiblity I didn't consider.
-- Dave Hargis, Microsoft Access MVP "Jerry Whittle" wrote: 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. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Klatuu" wrote: It is pretty straight forward. You are trying to create a table with more than one field with the same name. -- Dave Hargis, Microsoft Access MVP "Christopher" wrote: 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?
|
|
#5
July 14th, 2009, 09:41 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Error 3191 in Access
When you live in Illinois, corruption is the first thing that comes to
mind...... -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Klatuu" wrote: There's a possiblity I didn't consider. -- Dave Hargis, Microsoft Access MVP "Jerry Whittle" wrote: 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. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Klatuu" wrote: It is pretty straight forward. You are trying to create a table with more than one field with the same name. -- Dave Hargis, Microsoft Access MVP "Christopher" wrote: 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?
|
|
#6
July 14th, 2009, 09:49 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Error 3191 in Access
Now that is funny.
-- Dave Hargis, Microsoft Access MVP "Jerry Whittle" wrote: When you live in Illinois, corruption is the first thing that comes to mind...... -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Klatuu" wrote: There's a possiblity I didn't consider. -- Dave Hargis, Microsoft Access MVP "Jerry Whittle" wrote: 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. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Klatuu" wrote: It is pretty straight forward. You are trying to create a table with more than one field with the same name. -- Dave Hargis, Microsoft Access MVP "Christopher" wrote: 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?
|
|
#7
July 14th, 2009, 09:51 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Error 3191 in Access
There aren't two fields with the same name; I will run the compact and
repair. Thank you. "Klatuu" wrote: There's a possiblity I didn't consider. -- Dave Hargis, Microsoft Access MVP "Jerry Whittle" wrote: 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. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Klatuu" wrote: It is pretty straight forward. You are trying to create a table with more than one field with the same name. -- Dave Hargis, Microsoft Access MVP "Christopher" wrote: 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?
|
|
#8
July 15th, 2009, 03:09 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Error 3191 in Access
On Tue, 14 Jul 2009 13:41:01 -0700, Jerry Whittle
wrote: When you live in Illinois, corruption is the first thing that comes to mind...... SPLORT!!!! Jerry, you owe me a keyboard... -- John W. Vinson [MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
