#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Apr 2010
    Posts
    17
    Rep Power
    0

    Now this is strange...


    Developed a very simple access report, after the report is run, the data is returned, maybe 20 rows or so, not much......if I let the results sit on the screen for about an hour, msaccess.exe crashes and the following is logged in event viewer. my csr's started reporting this about a month ago, doesn't matter if it is run locally or via a network drive. i should say we use the access runtime (.accdr file) as i have the only license for access in the company and i create all the reports and queries. they'll typically run the report and then go about doing other things, time passes by and then they see the crash message. i wish there was more info, but this is all i have. can anyone point me in the right direction?

    ps - there's no VB code, modules or macros of anykinds, it's literally a query and then format it as a report to pretty up the results......ultra simple.....access 101 stuff....

    Level Date and Time Source Event ID Task Category
    Error 2/19/2013 9:37:01 PM Application Error 1000 (100) "Faulting application name: MSACCESS.EXE, version: 12.0.6606.1000, time stamp: 0x4e27ab6b
    Faulting module name: MSACCESS.EXE, version: 12.0.6606.1000, time stamp: 0x4e27ab6b
    Exception code: 0xc0000005
    Fault offset: 0x000be585
    Faulting process id: 0x1650
    Faulting application start time: 0x01ce0f0ba6935882
    Faulting application path: C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE
    Faulting module path: C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE
    Report Id: 673657a4-7b06-11e2-8315-180373728cfe"
  2. #2
  3. Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Jun 2011
    Location
    South Jersey
    Posts
    544
    Rep Power
    59
    no Idea why it's crashing, but maybe you could use an on timer event to close the report for them.
  4. #3
  5. No Profile Picture
    Contributing User
    ASP Discoverer (100 - 499 posts)

    Join Date
    May 2009
    Location
    Somerset, UK
    Posts
    135
    Rep Power
    92
    Do you see the same error if running the databaae with your full installation?
    Unfortunately Access runtime doesn't offer any way of debugging so if your database throws a 'normal' error then the database will just close.
    It may well be that there is a normal error happening but you can't see it.
    Regards

    JD

    Software-Matters

Similar Threads

  1. Strange
    By drl in forum ASP Development
    Replies: 8
    Last Post: January 18th, 2008, 05:37 PM
  2. Hmm very strange!!!
    By rollerblast in forum ASP Development
    Replies: 8
    Last Post: June 11th, 2006, 04:25 PM
  3. Very Very Strange
    By Sluap in forum ASP Free Lounge
    Replies: 4
    Last Post: March 23rd, 2006, 03:37 AM
  4. Strange one !!!
    By byatiraj in forum ASP Development
    Replies: 3
    Last Post: January 13th, 2005, 02:57 AM
  5. Strange, very strange return value on MySQL query
    By kboek in forum .NET Development
    Replies: 4
    Last Post: December 18th, 2004, 03:24 PM

IMN logo majestic logo threadwatch logo seochat tools logo