MS Access encountered an error ....

[Francois]

Hello,

I can no longer use access.

XP SP2 french,
Office 2003 pro SP3 (access 11.8204.8172 SP3)

I open the MDB file, this is OK. I can edit table columns too.
But as soon as I try to edit data, this is wrong.

The edit data window open, I have the navigation bar bottom and scroll bar.
But the working space of the window is white. There is then some
blinkings/display quirks in Access toolbar, and then I have the crash
"Microsoft Office Access has encountered ..." AppName msaccess.exe
ModName msaccess.exe.


This also happens when I try to create a new database.

I have removed and, resinstalled Office 2003, tried repair mode,
resinstalled service pack 2 for XP, have reinstalled Visual studio 2005. I
have reregistered msjt40.dll ...

The only thing not done is reformat the hd and reinstall XP.

Seems the only way to get rid of this !?(( is to use an hammer and buy a new
computer.

Thanks.

 

[Douglas J. Steele]

Before reformating, make a copy of your database and do a decompile on it.

Tony Toews has instructions on how to do this at
http://www.granite.ab.ca/access/decompile.htm

 

[Francois]

How do I decompile a new database I am creating ?

This error not only occurs on existing database (that otherwise open
correctly on other computers, also with XP SP3 and Access 2003 SP3), but
this error also occurs when I create a NEW database.

I can create a new database. I can add columns to the table. And then when I
try to add data to the table, I have the problem.


Thanks.

 

[Francois]

This error occurs on ALL the database I open on this PC. (about 10 MDB
files).
And do not occurs on the same files copied to another PC.

So the problem lies in the Access setup of that PC, not from the MDB file.

The problem is that I want THIS computer to open MDB files, not the others,
because this PC is mine, and others not . :-((


Thanks.

 

[John W. Vinson]

This error occurs on ALL the database I open on this PC. (about 10 MDB
files).
And do not occurs on the same files copied to another PC.

So the problem lies in the Access setup of that PC, not from the MDB file.

The problem is that I want THIS computer to open MDB files, not the others,
because this PC is mine, and others not . :-((

I'd suggest that you COMPLETELY uninstall Office (there are a lot of
components shared with other Office programs); download the office cleanup
tool from the Microsoft website; and reinstall Office from the source disk.

 

[gllincoln]

Hi Francois,

Here is the link to the page where you can download the Windows Clean Up
Tool.

http://support.microsoft.com/kb/290301

Hope this helps...
Gordon

 

[John W. Vinson]

Hi Francois,

Here is the link to the page where you can download the Windows Clean Up
Tool.

http://support.microsoft.com/kb/290301

Thanks Gordon! Bookmarked.

 

[Francois]

Unfortunately, it is still the same problem after using the so called office
cleanup tool.

Thanks.

 

[Francois]

I also tried /decompile.

Still the same problem.

 

[Francois]

Even more.

I have setup an ODBC query tool ( http://gpoulose.home.att.net/ )

If I configure a system DSN on my MDB file, using the access ODBC driver
(odbcjt32 version 4.0.6304), I can read the content of my file.

So I do not where access is failing, but it is failing very hard.

Regards.