Hello,

I have a split database that users access via the LAN. I have a table
tblAgr_Check_Out (ChkO_ID, Date_Checked_Out, User_ID,FS_Agr_Num).

The ChkO_ID is the primary key with an AutoNumber Datatype I have it set so
that it is Indexed and that no duplicates are allowed. Even when I have set
up this way it still allows some duplicates and it creates problems. The
FS_Agr_Num is also a unique key so I have tried to set both FS_Agr_Num and
ChkO_ID as combined primary keys.

I also allowed the FS_Agr_Num to be indexed and no duplicates allowed, which
seemed to have led to even bigger user problems. When I did this the errors
increased to the point that I had to recreate the table because it was giving
me an index and search key error. The database is in constant use, so the
FS_Agr_Num is always being assigned and reassigned to users.

What are some suggestions you would make to stop this errors? I am
considering going to converting the DB to Access 2002 but I am not if this
will help or cause more problem?

Thanks.