Results 1 to 8 of 8
  1. #1
    NejcZ is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2014
    Posts
    17

    Access database errors

    Hello again
    Sometimes, when oppening my database, i get this error? Any idea what's this about?
    It's a looooot of different topics on Google, but nothing specific. Also that was not happening, when my program
    was in early stages...
    Click image for larger version. 

Name:	Zajeta slika1.PNG 
Views:	17 
Size:	19.9 KB 
ID:	18303

    And this error appers from time to time when I'm working on data with forms. I'm sure there's something wrong with my code,


    becouse when this happens, a part of code does not execute (ticking checkbox in this case). I'm sorry that error is not in english,
    but I think you know it, it says Save, Copy to clipboard and Undo changes. Any ideas where should I start?
    Click image for larger version. 

Name:	Zajeta slika.PNG 
Views:	17 
Size:	57.8 KB 
ID:	18302

    Thanks!

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Maybe try importing everything into a new db and see what happens. Also you could try this.

    1. Open Access
    2. Click on Tools
    3. Click on Options
    4. Click on the Advanced Tab
    5. Uncheck the box next to "Ignore DDE requests"
    6. Close Access

    HTH

  3. #3
    NejcZ is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2014
    Posts
    17
    This is regarding first error, yes? Ignore DDE requests is not checked in my case.

  4. #4
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    YES. Check out this link for second error. http://support2.microsoft.com/kb/837937

    HTH

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    I've never seen the first error.

    As for the second, somehow the same record is being edited from two places. I encountered this early in developing a db and had to revise code so this did not reoccur.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    NejcZ is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2014
    Posts
    17
    That seems logical. Is there a way to see what is being edited twice, other then looking through whole code?
    I think I've found 1 probem, let's hope I'm right
    Last edited by NejcZ; 10-05-2014 at 08:36 AM.

  7. #7
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Hi -

    One thing to look for is a form that runs code that tries to edit the same record that is currently on the form, but is editing the form's source table. The code cannot edit the table record because the form has it locked.

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    I seem to remember it wasn't easy to find. Had to have just the right circumstances for the issue to happen. So a lot of testing and step debugging.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 4
    Last Post: 06-21-2014, 05:43 AM
  2. Access 2010 first macro - errors
    By DLParker in forum Forms
    Replies: 9
    Last Post: 10-16-2011, 04:17 PM
  3. Replies: 4
    Last Post: 10-07-2011, 10:58 AM
  4. Evaluate Database Errors
    By billgyrotech in forum Access
    Replies: 2
    Last Post: 08-09-2011, 01:29 PM
  5. Write Conflict Errors with SQL-Access DB
    By trb5016 in forum Access
    Replies: 5
    Last Post: 01-14-2010, 02:10 PM

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