ACCESS CRASH: Please help!

[targheauto]

Hi everyone! I hope not to bore any of you with this problem, I am new to the
forum and have searched and tried everything applying most of your wonderful
advices, but with no result!
I have an Access 2003 mdb file that I created myself, originally with Office2003
on WindowsXP SP2. The database contains about 5000 records and has a size
of about 6 megs.
No problems at all until I bought a new laptop with Windows Vista. Here I installed Office2003 and my mdb file began crashing.

What I did do so far:
1 - I imported all data and forms in a new mdb file
2 - I decompiled and recompiled it
3 - I applied a MS hotfix with no result
4 - I set msaccess.exe to run as Administrator (WHY MUST THIS BE DONE
ON VISTA???)

Symptoms:

This happens rather regularly: I double click the mdb file to open it, Access
opens with the mdb file, a system popup appears warning me that Access
was unable to open the file (???) even if it succeeded opening it!
Then, I open any form, I close it and I close the mdb file by clicking on
the close button of the Database window ("X") ---> CRASH !

I have a main form with a "Close" button that performs DoCmd.Quit.
If I use that one Access does not crash!

I configured the database to compact on close.

Looking in the windows event registry, I find this event:

MSACCESS.EXE

11.0.6566.0
42cdb33e
ntdll.dll
6.0.6000.16386
4549bdc9
c0000374
000af1c9
db0
01c7f3e9535ea4fd

Any of you had the same problem? Is anyone willing to help?
Thank you so much in advance!
Alex

 

[odin1701]

Have you tried a Compact and Repair?

 

[Moniker]

Is there something that runs when opening the DB? As in, is there an AutoExec macro, or is there a form that automatically opens when the DB is opened, and that form has something in the Initialize, OnLoad, or OnOpen events? That sounds a lot more like a code incompatibility rather than a problem with the DB itself. I can't be sure because everything I've run between 2003 and 2007 works fine (both on XP and Vista).

 

[targheauto]

Thank you guys for your answers!
First, yes I already compacted and repaired many times, I also decompiled
and recompiled importing in a new DB.
Second, yes there is a form opening as default starting point. This form just contains some buttons to access to other forms, like a menu,
and checks if a form is already loaded with a code like this:

Function Caricata(strFrmNome As String) As Boolean

Const conStrutturaMaschera = 0
Dim intX As Integer

Caricata = False
For intX = 0 To Forms.Count - 1
If Forms(intX).FormName = strFrmNome Then
If Forms(intX).CurrentView <> conStrutturaMaschera Then
Caricata = True
Exit Function
End If
End If
Next

End Function


Anyway, this DB always worked fine for years on WinXP SP2, the problems
started when opening it on Vista.
Also very weird is the system message I get each time I double click on any
mdb file saying that the file could not be found, but it opens it anyway in Access .... if I first launch msaccess and then open the mdb file from inside
the application the error won't pop up ...!
Which other tests could I do? Now it just crashes on closing but who knows it may crash in the middle of a data insert?
Also, what could have the ntdll.dll library has to do with the problem?

Thanks, you are a great resource for me!!!
Alex

 

[ByteMyzer]

See if this thread helps

 

[targheauto]

Thanks, I already seen this before. But I don't think it applies to my case
because I just open an mdb file locally on my PC and it is not shared with
other users. Anyway, I have already applied Microsoft Hotfix for KB935366
with no results
Also, could someone explain why in Vista I have to run msaccess.exe as
Administrator? Do I also have to make it run in WinXP SP2 compatibility mode?
I have Office 2003 installed.
Thanks,
Alex

See if this thread helps

 

[targheauto]

Just to keep this thread up (forgive me but I need to find a solution!):

1 - Whenever I open an mdb file doubleclicking on it Access opens with
the file open but a system message warns me that it was impossible
to find the file!
2 - I configured msaccess.exe to run as admin, why is this required on Vista?
3 - I downloaded a trial version of a popular repair utility and it did not detect
any corruption in the DB
4 - I tried opening several (old) backup copies of my DB and each has the same
behavior: when you close the DB window by simply clicking on the X button,
Access exits and crashes .....
5 - I tried opening a couple other DBs (like Northwind.mdb) and the problem
does not appear ...!

Please help, I am desperate

Alex

 

[ByteMyzer]

What happens if you create a new database file and import all of the objects from the old file into it?

 

[MStCyr]

Hi

You may have to resort to uninstalling and reinstalling Access

 

[targheauto]

Already done once. And I had the same problem on the newly created DB.

What happens if you create a new database file and import all of the objects from the old file into it?

 

[targheauto]

I also considered switching to Office 2007 but I am too scared of
potential compatibility issues .... what may happen opening a 2003 mdb
file with Access 2007? Is it possible to reopen it in Access 2003 later
on another machine?
Thanks, Alex

PS: Does any of you know if (and why if yes) Access must be executed
as administrator on Vista? Does it also have to be launched in WindowsXP SP2 compatibility mode? Thanks!!!