Cannot define field more than once. (Error 3191) after shuffling o

A

Andrew P.

Hi

I just shuffled the order of fields and added some in a table. Now I cant
save it, as it complains with "Cannot define field more than once. (Error
3191)". I think it somehow remembers the first location that a field was in,
and then sees the new location and thinks its a duplicate.
 
J

Jeanette Cunningham

Andrew,
Check very thoroughly that you don't have the exact same field name more
than once.
Personally I find that this can happen easily when I am playing with new
tables and editing table fields.

Jeanette Cunningham
 

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

Error 3191 in Access 7
Error message when trying to save: Cannot define field more than 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
Export large query from Access 3
Exporting data error: cannot define field more than once 2
Error MEssage - Cannot Define Field More Than Once 2

Top