Results 1 to 7 of 7
  1. #1
    datahead is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2015
    Location
    Missouri, USA
    Posts
    19

    What happened over the long weekend?


    I have an Access 2007 front end tied to a MS SQL Server 2014 back end. One of the tables is basically an inventory list. The primary key is an INT, is identity, increment 1. At the end of the day on Thursday (07-02) the ID count is up to 965. This morning (07-06) I add a line item and I am at ID 1958. Nobody with access to the database was in the office over the weekend. I see a reference to "pages dumped: 506" during a backup that occurred on 07-04 and 07-05 in the logs.

    This does not make sense to me. It almost looks like someone copied 992 records, pasted them, realized the error and then deleted them. Any other possibilities here?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Do you have any log records/audit trail that identifies who copied and deleted records? Or any weekend activities?
    When was your latest backup? Can you compare records/counts with that?

  3. #3
    datahead is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2015
    Location
    Missouri, USA
    Posts
    19
    Sorry I stepped away from this thread for so long. Too many things going on here.

    This issue is now happening in multiple tables and two separate databases. I would not really care that my primary keys are jumping up in number but we use the primary key in the equipment table as a stock number for the items we order. When items come in we use an old fashioned pricing gun to tag the items here in the building.

    I keep seeing log entries like this:
    07/20/2015 02:18:39,spid31s,Unknown,Starting up database 'AT_Portal_v1.02'.
    07/20/2015 02:03:23,Backup,Unknown,BACKUP DATABASE successfully processed 0 pages in 4.014 seconds (0.000 MB/sec).
    07/20/2015 02:03:23,Backup,Unknown,Database backed up. Database: AT_Portal_v1.02<c/> creation date(time): 2015/06/08(08:26:35)<c/> pages dumped: 506<c/> first LSN: 190:416:1<c/> last LSN: 190:440:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'{EFD93B34-8664-40D1-BE26-14DD73DB5D5C}1'}). This is an informational message only. No user action is required.
    07/20/2015 02:03:20,spid51,Unknown,I/O was resumed on database AT_Portal_v1.02. No user action is required.
    07/20/2015 02:03:19,spid51,Unknown,I/O is frozen on database AT_Portal_v1.02. No user action is required. However<c/> if I/O is not resumed promptly<c/> you could cancel the backup.
    07/20/2015 02:03:19,spid51,Unknown,Starting up database 'AT_Portal_v1.02'.

    I do not know what the coloration could be for an INT column set for increment 1 to just skip over nearly 1000 numbers. I have not seen any data loss but I need to figure this one out.

  4. #4
    datahead is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2015
    Location
    Missouri, USA
    Posts
    19

  5. #5
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Thanks for posting that link.

  6. #6
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    but we use the primary key in the equipment table as a stock number for the items we order
    That is generally a bad idea for the reasons you are experiencing.

    You might find this link informative http://www.utteraccess.com/wiki/index.php/Autonumbers

  7. #7
    datahead is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2015
    Location
    Missouri, USA
    Posts
    19
    I have a "sandbox" database I use for testing things. The primary key column in SQL is the Autonumber data type in Access. When I try to change another column to the Autonumber type in Access it states I can only have one Autonumber column per table.

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

Similar Threads

  1. weekdays versus weekend
    By webisti in forum Access
    Replies: 6
    Last Post: 09-10-2013, 02:27 AM
  2. What happened to my form??
    By tstoneami in forum Forms
    Replies: 1
    Last Post: 08-29-2013, 05:10 PM
  3. What happened to my properties?
    By hertfordkc in forum Forms
    Replies: 1
    Last Post: 11-12-2011, 02:50 PM
  4. what happened to radio buttons?
    By judomum in forum Forms
    Replies: 1
    Last Post: 10-09-2011, 11:58 AM
  5. What the world happened!
    By SemiAuto40 in forum Programming
    Replies: 2
    Last Post: 10-03-2011, 10:59 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