New record replaced with random one with linked SQL tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
hi Rick,
When I close the table and open it again, the new record is inserted so
everything works.
Click to expand...
What do you mean?
What could be the problem of this?
Click to expand...
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 <--
 
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).
 
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.
Click to expand...
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).
Click to expand...
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 <--
 
Back
Top