> I currnetly have several SQL Server 2000 tables linked into an MS Access
> database application. When tryingt o update NEW records created using
> Access, the operation fails stating another user has made changes to the
> record. However, if i update a record that was alreayd in the database,
the
> operation succeeds. Additionally, the record can be updated successflly if
it
> is done when opening the table directly in SQL Server.
>
> anyone have a clue to point me in the right direction?

"Steve Thompson" wrote:

> "aviens@trgusa.com" <avienstrgusacom@discussions.microsoft.com> wrote in
> message news:153007C2-7F07-4652-B4EB-90EE852A1592@microsoft.com...
> > I currnetly have several SQL Server 2000 tables linked into an MS Access
> > database application. When tryingt o update NEW records created using
> > Access, the operation fails stating another user has made changes to the
> > record. However, if i update a record that was alreayd in the database,
> the
> > operation succeeds. Additionally, the record can be updated successflly if
> it
> > is done when opening the table directly in SQL Server.
> >
> > anyone have a clue to point me in the right direction?
>
> Define a primary key on your SQL Server table, and additionally add a
> datatype of timestamp. From Access, remove and re-link the table(s).
>
> Steve
>
>