Louisa Burke

Louisa Burke

  • NA
  • 1
  • 2.7k

System.AccessViolationException

Apr 3 2012 8:45 AM
Trying to run a report gives a System.AccessViolationException only on XP
machines.
I've tried various things I've found on forums to no avail...can
anyone help??

Visual Studio 2010
Compiled for .Net Framework
2.0
X86
Access DB with link tables to SQL DB
Crystal
Reports

Error with one report but not with others that go through
same/similar code

System.AccessViolationException
occurred
Message=Attempted to read or write protected memory. This is often
an indication that other memory is corrupt.
Source=dao

Cannot load
DLL: '?????L?'

I've added in the line of code I believe it falls over on
but I have to stress that other reports run through this code with no problem
and the report that fails only does so on XP machines!


rs = d.OpenRecordset(strSQL, IIf(blnSnapShort, dao.RecordsetTypeEnum.dbOpenSnapshot, dao.RecordsetTypeEnum.dbOpenDynaset), IIf(blnReadOnly, dao.RecordsetOptionEnum.dbReadOnly, dao.RecordsetOptionEnum.dbSeeChanges))