Access Violation when opening any Access Table

By: Quinn Wildman

Abstract: Bad DAO installation causes this problem.

Q. If I attempt to get a list of tables in SQL Explorer against an Access database, or just execute a SQL statement I get an Access violation, even though the Microsoft Access product works just fine. What can cause this?

A. In general terms your DAO install is bad in some regard. Obtaining a newer version of DAO350.DLL or OLEAUT32.DLL generally solves the problem. See http://support.microsoft.com/support/kb/articles/Q231/8/41.ASP?LNG=ENG&SA=ALLKB for additional information.


Server Response from: ETNASC01