troubleshooting Question

MS Access 2007 VBA: crash on Set rst = qdf.OpenRecordset , , dbForwardOnly

Avatar of katerina-p
katerina-p asked on
Microsoft AccessVisual Basic ClassicWindows Server 2008
35 Comments1 Solution3278 ViewsLast Modified:
Hi All,

Access is crashing on server machines when running the line "Set rst = qdf.OpenRecordset , , dbForwardOnly". This is a full crash, and the exception given is:

Problem signature:
  Problem Event Name:      APPCRASH
  Application Name:      MSACCESS.EXE
  Application Version:      12.0.6606.1000
  Application Timestamp:      4e27ab6b
  Fault Module Name:      MSVCR80.dll
  Fault Module Version:      8.0.50727.4940
  Fault Module Timestamp:      4ca2b271
  Exception Code:      c0000005
  Exception Offset:      000172d7
  OS Version:      6.1.7601.2.1.0.1296.17
  Locale ID:      2057

Additional information about the problem:
  LCID:      1033
  Brand:      Office12Crash
  skulcid:      1033

Read our privacy statement online:
  http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

If the online privacy statement is not available, please read our privacy statement offline:
  C:\Windows\system32\en-US\erofflps.txt

It's a 'regular' query, has been working for ages and I cannot replicate the crash when using my local testbed, only happens on production. This I suppose could mean to do with locking, or operating systems (64 Win Svr 2008 R2).

Does anyone have experience of this/have any ideas? I have tried decompiling and recompiling/compacting etc.

Many thanks!
Katerina
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 35 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 35 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros