update record with link table

N

ngan

I created an access xp mdb file and have a link table to a
sql 2k table. When I go into the table or create a select
query for one record and try to modify a field, it tells
me:

Write Conflict
this record has been changed by another user since you
started editing it...
I have the choice of copying it to the clipboard or drop
the changes.

This happens if i use a DSN connection or a dsn-less
connection.

This is normal? I can do updates/modifications if I use
Update queries, but not select queries.

what if I want to create a form to modify records in a sql
table?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top