Access FE, SQL BE, Some tables, won't let me edit (or delete) my records!

B

BrianDP

i have a linked table linked from sql Backend into Access Front end.

If I create a record, I can edit it, and change it but once it gets written, I seem to lose access to this record. I can't modify it, and I cannot delete it!! Help!


I can go in through the SQL back end tools, and delete and update my record that way, but I cannot figure out when I can change most records, but not any ones i create!
 

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

Similar Threads

Linked SQL Tables don't report Cascading Updates and Deletes 2
Why won't Access assign a Primary Key ID to my linked SQL Table? 2
SQL not importing records from ACCDB 2
delete duplicates 0
Conneting to SQL server, Need advice 4
Linked tables to SQL and how to handle triggers on SQL ??? 4
Saving Record using Access FE to SQL BE 1
Make Table Query Only Runs After Edit 0

Top