Results 1 to 3 of 3
  1. #1
    ManTIS is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2014
    Posts
    2

    ACCESS database not allowing record deletions

    Dear ACCESS gurus,



    I developed split ACCESS database: the front-end is in ACCESS with Visual Basic programming, and the data comes from linked to tables on our SQL server. I'm using ACCESS 2010.

    For a multi-user environment, the database was successfully deployed as an .accde file. Then the owner wanted some changes made. I made a copy of the full version (.accdb file) and proceeded to unlock previously locked fields and, allowed deletions on a subform.

    To prevent data loss, I converted links to live tables and made them local. I then re-set the relationships on the copy and I'm able to edit the relationship properties. Everything works fine on the COPY, i.e. the one with local tables, so I made the same changes to the live version. However, the live version will not allow deletions, instead I get this message:

    "The Microsolf database engine stopped the process because you and another user are attempting to change the same data at the same time."

    As many ACCESS programmers will know, ACCESS does not always provide meaningful error messages - in fact, it sends you way off tangent. In this case there are no other users working on the system because it's in a secure area. Secondly, on my live copy, I'm unable to edit the Relationships window. I'm under enormous pressure to get this database functioning again - so I would appreciate any help/suggestions from this forum. Thank you so much!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    possibles:

    The SqlSvr permissions wont allow deletion by user
    SqlSvr requires in index for deletes to work
    properties on the form are not dynaset
    the delete query is part of a join
    if part of a workgroup, permissions again.
    the relationship is such that deletes cant happen.

    check all these.

  3. #3
    ManTIS is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2014
    Posts
    2
    Dear ranman256, Thanks very much - will try these suggestions and get back to you.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 04-01-2014, 02:03 AM
  2. Replies: 3
    Last Post: 05-29-2013, 02:34 PM
  3. Subform not always allowing new record creation
    By Canadiangal in forum Forms
    Replies: 1
    Last Post: 03-28-2013, 11:00 PM
  4. Split Database only allowing single user access
    By terricritch in forum Database Design
    Replies: 2
    Last Post: 11-08-2011, 11:12 PM
  5. Deletions vs. Edits
    By jparker1954 in forum Forms
    Replies: 7
    Last Post: 09-20-2011, 08:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums