Recent content by pau

Re: "duplicate values in the index, primary key, or relationship" Error. Help needed I was wondering about that too. I haven't changed those settings, but this is a work computer, so they may have changed them from the defaults before they distributed copies of Access to the workstations. I'm...

Re: "duplicate values in the index, primary key, or relationship" Error. Help needed Yep, I tried that too. The randomly generated IDs eliminated the "duplicate values in the index..." message, but the the second record that was entered would not be saved in the BE table. Everything would to...

Re: "duplicate values in the index, primary key, or relationship" Error. Help needed It seems like updates from the BE are not being communicated to the various FE copies when in use at the same time by multiple computers. The autonumber doesn't generate the same number twice for one user, but...

Re: "duplicate values in the index, primary key, or relationship" Error. Help needed I tried a very simple test database. One table with three fields, an autonumber ID, a date field,and a text field. Two forms, one to view the date and text fields and another in data entry mode. The same error...

Re: "duplicate values in the index, primary key, or relationship" Error. Help needed Yes to all. Single table. The form and subform were built with the form wizard. This is a data entry form, so I'm not using an SQL query to filter anything. I haven't tried this yet. It only happens with...

Re: "duplicate values in the index, primary key, or relationship" Error. Help needed Ok, so it seems that what is happening is something like this... There are 10 records. User A begins adding a new record and ID 11 is created for that record, but not yet saved in the table. User B, sometime...

Re: "duplicate values in the index, primary key, or relationship" Error. Help needed I tried testing it with another user after removing the index. The same error was still occurring.

Re: "duplicate values in the index, primary key, or relationship" Error. Help needed Thanks for the reply. I checked and there was a custom index. I haven't had a chance to test with other users yet, hopefully this solves the issue. If the index was causing this problem, is it possible that I...

"duplicate values in the index, primary key, or relationship" Error. Help needed I have a split Access 2007 database with the backend on a shared drive and copies of the frontend distributed to users. It worked perfectly when I tested it on my computer, even testing multiple copies at once. But...