DAO.Recordset [3022]

[skiwi]

I'm getting this error when I drag a package into a model document container.
A project integrity check shows nothing wrong.

What can I do, I can't complete a document  

[Geert Bellekens]

You could check the dbError.txt (since 9.0 located in the %appdata% and no longer in the program files folder)
That usually gives you some more details about the issue.

Geert

[skiwi]

Thanks

12/04/2011 2:51:00 p.m.
DAO.Recordset [3022]

The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship.  Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

Context:
      SQL: Select * from t_object where Object_ID=0

[Takeshi K]

Tools | Data Management | Reset IDs, then select Reset All Tables and press Go button may solve the issue.

[skiwi]

Tools | Data Management | Reset IDs, then select Reset All Tables and press Go button may solve the issue.

Great tip thanks. I don't think this was the issue in my case.
I seem to have got round the problem by doing a compact and repair using Access.