Results 1 to 12 of 12
  1. #1
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    126

    Records Disappearing - Urgently need help


    I have created a database on a network drive, that was working fine for several months. Now, records are disappearing (being deleted) by the "system." I have put security on forms to not allow deletions, but the problem is continuing, and becoming worse (more records disappearing).

    The database is currently 21.7 MB. Are there any size limitations that could be causing this?

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,440
    The size limitations of an access database is roughly 2gb so you shouldn't be having any problems relating to size, and your database is relatively tiny so I doubt compact/repair will do much for you. How many users do you have and now many of them know how to get to the table level? Are they perhaps editing the data on your table instead of on your forms? Have you tried hiding the tables so that someone would have to know how to 'unhide' them to delete records? this would really only work if you had users that were unsophisticated enough to know they could create a query and delete records in the query as well.

    Your options are pretty limited if you have users that are relatively sophisticated.

  3. #3
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    126
    The navigation pane is locked out. There are about 25 users. They aren't very sophisticated.

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,440
    are you using bound forms?

    if you are it's still possible for people to delete records, want to provide a sample of your database it would be easier to help you with a sample.

  5. #5
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    126
    UnitData.zipClient2.zipHere is database and client.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,845
    You could try an Audit Log process to attempt to track issue. Review http://allenbrowne.com/AppAudit.html

    Why do you have MakeTable queries?

    A db design that routinely creates new tables is probably not optimal.

    The navigation pane can be expanded with F11.

    Also, presume you know that holding down shift key when opening db negates many optional db settings?
    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.

  7. #7
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,440
    In addition to what June has pointed out, where in your process are records getting deleted? from all tables? From one table in particular? from a few tables but not others? How do you know items are being deleted, do you have screen shots of data that are no longer in your database? Have you got orphaned data?

  8. #8
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    126
    The problem is with records in the "record requests" table. After a record is created, a routing slip is printed. Later, going in to update the request, it isn't there. I have confirmed this on several occasions.

  9. #9
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    126
    June,

    The make table queries are used to create temporary tables used for reporting.

    I did not know about F11 or holding down shift while opening.

    Thanks for the link for creating an audit trail. This should help us track and isolate the problem. Thanks!!!

  10. #10
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,440
    So what happens in your normal flow between the time the routing slip is produced and it's accessed again, are you able to, at will, reproduce the problem, if so can you tell me how you're doing it. I do not see any delete queries in your object window but I don't want to go wading through any code you may have looking for vba code that may be manipulating the data.

    Have you tried making your forms into unbound controls (this is my preferred method because data is not changed unless a specific event is triggered like a mouse click or a confirmation click etc.)

  11. #11
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,845
    Instead of MAKE TABLE queries, just create the tables and leave them permanent. Then delete records before each process that uses the tables.
    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.

  12. #12
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    126
    Problem resolved.

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

Similar Threads

  1. Disappearing Act
    By CementCarver in forum Forms
    Replies: 4
    Last Post: 09-04-2013, 03:08 PM
  2. disappearing gridlines
    By lugnutmonkey in forum Reports
    Replies: 2
    Last Post: 05-06-2013, 01:26 AM
  3. disappearing combo box value
    By j6sander in forum Forms
    Replies: 5
    Last Post: 09-11-2012, 10:22 AM
  4. Replies: 15
    Last Post: 12-28-2011, 05:47 PM
  5. The amazing disappearing VBA code
    By Michele Keck in forum Forms
    Replies: 2
    Last Post: 10-01-2010, 11:44 AM

Tags for this Thread

Posting Permissions

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