Access 2010 on SQL 2005 Crash Problem 1

[idbr]

Hi,

I have an A2010 db front end, linked to a SQL Server 2005 back end. I'm seeing multiple crashes and can't see where the problem lies.

Usual crash point is opening the database with the followign details:

Problem Event Name: APPCRASH
Application Name: MSACCESS.EXE
Application Version: 14.0.6024.1000
Application Timestamp: 4d83e4fc
Fault Module Name: VBE7.DLL
Fault Module Version: 7.0.16.19
Fault Module Timestamp: 4d430aec
Exception Code: c0000005
Exception Offset: 00023081
OS Version: 6.0.6001.2.1.0.256.6
Locale ID: 2057

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

I think it might be something to do with veryfying the odbc connection to the server?

Interestingly, if a new user opens the db, they can't access the linked tables - they have to manually link them in themselves. Could be related?

Connection string for the linked tables:

DRIVER=SQL Server Native Client 10.0
DATABASE=MyDatabase
APP=Microsoft Office 2010
Trusted_Connection=Yes
SERVER=MyServer

I'm totally stumped on this. Any suggestions welcome.

Thanks, Iain

 

[MazeWorX]

if you have any code running when you open the db it would be helpful if you posted it

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

 

[idbr]

Nothing running at startup. Not even startup options set. Crash interval is in the order of 2-3 seconds once corrupted, or immediately I try to open any form.

Attemting to import the objects to another db throws the same error.

 

[MazeWorX]

You need to read

http://support.microsoft.com/KB/2625046

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

 

[idbr]

That looks very helpful, thanks. I'll let you know if it solves the problem.

 

[idbr]

Hi MazeWorX,

Installing the fix from the KP has solved my problem and we're now up and running with no crash issues.

Thanks again for your help with this.

Regards, Iain

 

[idbr]

* or KB even...