Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Nov 2008
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 3027 Error, but I can still add records

    I'm using Share Point 2007 with MS Access 2007 as an inexpensive contact management system. The trouble is when I run a query, I receive a 3027 (Destination is Read Only) error. If I go to the Table and open it, I can easily add whatever I want without error messages. But, if I run a SQL query or run a query (created through Access' Query Builder), both will tell me that I can't.

    Any thoughts on this?

  • #2
    New to the CF scene
    Join Date
    Nov 2008
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    More information....

    When I generate a form from the table directly, it allows me to run an add record macro, but as soon as any query or VB code is run, it throws the locked record error again.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •