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



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