DAO, MS Access Problem

[kamavarapu]

I have developed an application with back end as MS Access,
VC++ using DAO for database connectivity.
Application is giving "Invalid Page fault" error , at the time of creation, and when ever code refers to database and this is happening in machines where Visual Studio is not installed.
If I Install visual studio->VC++->VC++ Runtime libraries, then application is running without any error.
Pl write to me any suggessions.

[antares686]

Are you using any special controls or references in your Access DB. Almost since this seems related to DAO functionality I would suggest downloading and installing the latest MDAC from Microsoft to make sure they are all running the same.

MDAC Available Here (http://www.microsoft.com/data/)

Do make sure you test on another machine first as there could be updates in the MDAC in relation to the one installed on your machine that can lend to errors.

Finally I suggest moving from DAO connectivity to ADO. Access 2000 and later have started moving toward wanting ADO as the primary method.