Access crashes on save

[Martijn]

Dear all,

I am using a database with several linked tables and use the form interface
(with several tabs and subforms). When changing a value (does'nt matter which
one) and switching to another tab, Access crashes (with the standard Access
error).

I have already tried some suggestions from the forum, but no luck:
- copied complete tables, forms and queries into a new database.
- used the Repair and compress database function
- upraded the database to Access 2002.
- using the /decompile function (MSACCESS.EXE / decompile "path")

It is a database I use with a lot of important data and I am hoping that
someone can help me. I am not the one who created the database, and not that
expierenced with it. But I am able to perform simple actions if described to
me.

Thanks in advance,

Martijn

 

[Steven Chicago,Illinois]

Dear Martijn,

1st. I hope you have a Good Backup of everything before you started trying
to fix it yourself. If this is a very important database that you didn't
create, you may want to see the person that created for help. If that person
isn't availble, then find someone that is just as experienced or even more
experienced than the person that created it. I didn't build my car, and
sometimes I try to figure out what is wrong with it and fix it myself to save
money. But sometimes I have to brerak down and get the professional to fix my
car, that is if I can not afford to wreak my car or buy another car. You may
be getting near the point of wreaking more than your fixing. That is why I
hope you have Backups prior to anything you tried to do to fix the originial
problem(s).
2nd. Could your problem be as simple as a lost Link? Or a Master Table that
needs to be updated for a new data item your trying to add to the database?
We can not even guess, because you have not mentioned what the real error
message is? Is the error message the same error message you got before you
tried to fix things on your own? Or is there a new problem?

3rd. You say "Access crashes on save". If it truely is crashing on a save,
could the location where your trying to save to be out of space? Could you
not have rights to write to that location/disk drive/folder,etc.?

You don't mention how you have determined it is crashing on a save? How and
what is it trying to save?

What do you call Access crashing? Does that mean it freezes up your machine?
Does that mean you have to re-boot to get things going again?
Could it be you are not being patient enough and waiting long enough for it
to do the save/update? I know sometimes my machine/network can run really
slow and Access doesn't display a message telling me it is really working and
doing what I want, so I go into task manager and I can see Access is working
it's heart out for me. So I just wait and eventually it does get done.

I once had a user that told me their machine was broken. I told them over
the phone to re-boot the PC. They went and did it. I asked if the screen was
now back to the startup menu? They said no, it had the same error message on
it. I asked them to explain to me in detail how they re-booted their PC. They
explained how they powered it off and then back on. The only problem was they
had done that to just the monitor (which they thought was the computer), not
the PC. So the picture of the problem that you say to us, needs to be more
exact (detail - quotes of the error message and steps you did to get there),
paint the full picture to us. And sometimes the Doctor/auto mechanic has to
see and touch the patient/PC/Database to really know what is wrong.

Good luck and Hope you have those backups,
Steve

 

[Steven Chicago,Illinois]

Dear Martijn,

1st Good you have backups.
2nd " I am not sure if the problem is as simple as a missing link."
"The error has not changed since I have been trying to fix the database."

As for a missing link, if none of the linked databases have been moved or
the database itself hasn't been moved, then you should be right. Though you
could check the links and see if they all are found to be ok. Under Tools,
Database Utilities,Linked Table Manager Click on Select All and lick on OK,
it will try to refresh all the links. It could take a while. It should give
you a message "All selected linked tables were successfully refreshed". Of
course backup before doing this.

3rd " I think it is crashing on save, as when I switch to another tab of the
formI think it depends on how it is programmed. When you switch to another tab
it seems to be doing a save. Is the way your switching between tabs the way
the original access programmer wanted you to exit that form? Or is there a
save button or exit button that you should be or could be using?

I ask the above because the way you are crashing is something to worry
about. I have had that problem happen to me. I never figured out what changes
I had made that had caused the problem, I just had to re-code whatever I lost
.. I think it was a report I had been developing. But I deleted that copy of
the database, restored a good backup of the database, and started from
scratch on the report.

So I guess I have to ask if you have a backup copy of the database before
the crashing problem started?

If you want to try and figure out why it is crashing, I would guess you need
to start looking into the code and see what is happening when you change
focus and jump from that form/tab to another form/tab? On that form there
must be some VBA code in a EVENT that executes and does something to make
Access unstable enough to want to close itself down.

Does it only happen when you switch from that one particular form? Or does
it happen between other forms/tabs?

Steve

 

[Steven Chicago,Illinois]

Dear Martijn,


I just was cheikng some other sites for Access crashing and came across a
New article that reminded me of my problem. I may have been using a yes/no
field, and the table may have had null values in the yes/no field.

Look at:
http://allenbrowne.com/NoYesNo.html

I am only guessing, but when you enter the data are you entering data in all
the data fields, and are you populating them all with valid data values?

You could see what Tables the form is updating. Then check the Table
definitions for those Tables and see if there are any yes/no fields or
anything else that sticks out that could be cause a problem that causes
Access to shut itself down.

Good Luck
Steve

 

[Martijn]

Dear Steven,

Thanks for your reply.

When reading below message I got to the conclusion I might have given myself
not enough credit regarding my knowledge of access. I am familiar with Access
regarding the simple databases (several tables and some forms with subforms)
all via the wizards and easier insertions.

Regarding your questions:

1st
Yes, I have made a backup for every step I took that I described in the
first message.

2nd
I am not sure if the problem is as simple as a missing link. I doubt it
because the database has not changed in years. If there is a way to found
out, I am all ears. The error has not changed since I have been trying to fix
the database.

3rd
I think it is crashing on save, as when I switch to another tab of the form
(access always saves the data automatically, isn't it?) a hour-glass apears
and after a fraction of a second the database is closed with the error. It is
trying to save data I entered and/or changed.

This is the error I get:

"Microsoft Access has encountered a problem and needs to close. We are sorry
for the inconvenience."
__________________________________________________________________
Error signature:
AppName: msaccess.exe AppVer: 10.0.2627.1 ModName: msjtes40.dll
ModVer: 4.0.8618.0 Offset: 00008b6a
__________________________________________________________________
I am unable to copy and past the technical report.

When clicking the send error report button, I get the following website:
http://wer.microsoft.com/responses/....0.0?SGD=7e2eb7a3-2cb6-4118-a545-5cc349d7285c

Which only tells me that updates are available, but not that the problem is
identified.
I am unable to download those updates as I am working on a company computer
and access to updates are restricted.

It does not freeze up the machine. No reboot required, nor any effect of
reboots.

I hope this is of more help to you.

Regards,

Martijn

 

[Martijn]

I should add this info:

The data I changed in the field is saved and available when reopening the
database.

 

[duanemoore]

Martjin,

Make sure you have the latest service packs installed. I believe the
latest version is 2.0.

A lot of people struggle to find out what is wrong with their design
when they get the error message you got. A lot of normal windows
actions can cause this, especially during development. My best
suggestion is to create a fresh, empty database (.mdb) and select all
objects in the old .mdb and export them to the new .mdb. You'll have
to check the References in the IDE window and make sure the new .mdb
has the same settings as the old. Also you will want to do the same
for the Options in the Access window, and the same for Startup
options. Make sure that you open the IDE and compile the VBA code and
save. Exit Access and archive a copy of your original .mdb. Rename
the new .mdb to the old name then reopen it. Tools > Database
Utilities > Compact and Repair. If it blows up, it isn't your code
acting up -- it's theirs. Try it again. You might find that it
forgets the name of your .mdb and you may have to rename back. Now
you can try it again.

If you need further help, start at

http://www.allenbrowne.com/tips.html

Good luck!

Duane

 

[Steven Chicago,Illinois]

Dear Martjin,

Let us know when you have time how things turn out.

The answer to your problem is very educational for alot of us that search
these
discussions for answers to problems we come across or may face in the future.

Thanks and Good Luck,
Steve