New record replaced with random one with linked SQL tables

[Guest]

Hi,

I have a SQL back-end and a Access front-end with linked tables.
When I add a record in one specific table in access (directly in the table)
and I move the cursor to an other record, the record is saved but access
replaces the values with a random record (of the newly added record).
When I close the table and open it again, the new record is inserted so
everything works.

What could be the problem of this?
Thank you in advance

 

[Stefan Hoffmann]

hi Rick,

When I close the table and open it again, the new record is inserted so
everything works.

What do you mean?

What could be the problem of this?

Records are normally unordered. If you need a special order, you need to
define it and to requery your data source after an insert.

mfG
--> stefan <--

 

[Guest]

Sorry for the confusing explanation.
I made a little screencapture movie of the problem, it's hard to explain in
words.

http://muronline.nl/accessproblem.wmv

When I close the table window and re-open it again the I see the new record,
so the INSERT is good, but access is not updating the record well (when
updating the PK).

 

[Stefan Hoffmann]

hi Rick,

sorry i lost the focus on this thread.

I made a little screencapture movie of the problem, it's hard to explain in
words.

Okay, I see.

When I close the table window and re-open it again the I see the new record,
so the INSERT is good, but access is not updating the record well (when
updating the PK).

Check if the PK listed in the linked able is the same as on your SQL
Server.

Add a TIMESTAMP column to your table on the backend.

Check your installation:
-MDAC
-Jet
-SQL drivers
-service packs of SQL server

mfg
--> stefan <--