Microsoft Access has a problem

[Peter Kinsman]

I do work for a company which runs Microsof Access on a Terminal Server.
Weeks can go by without any problems and then we have a few days where they
get the "Microsoft Access has a problem" screen whenever an database is
opened. If autostart is disabled and the code behind a form loading is run
step by step all is well, but I am wondering if anyone else has had a
similar problem.

Many thanks

Peter Kinsman

 

[Steven Chicago,Illinois]

Dear Peter,

1. Do you have good backups and backup schedule?

2. Could you mention the version of Access that you are running?

2B. What is your structure? Front end on users systems/back end on network?
Many users or 1 user? etc..
Large database or databases or small.

3. How are you fixing the problem or getting around the problem?

4. Do you ever Compact the database(s)? (Re-organize, repair, clean out the
deleted records, etc)

5. Is the Database(s) being updated heavily or are they more read-only?

6. Have you searched the Discussions for the error message you are
receiving? What is the specific error message? Does access shut down?


It would be more helpful in trying to understand the problem if the group
knew some of the answers to the questions I have asked.

Thanks,
Steve

 

[Peter Kinsman]

Dear Peter,

1. Do you have good backups and backup schedule? Backups are taken twice a day.

2. Could you mention the version of Access that you are running? 2003

2B. What is your structure? Front end on users systems/back end on
network?

Most tables are held in Tables.mdb
The database that went faulty today uses data in a number Access tables to
generate transaction records on the company's AS/400. Earlier in the day, I
had moved some of the tables it uses from a front end database into the
Tables.mdb I wonder if Access is trying to start the record counts before
all the tables have been linked.

Many users or 1 user? etc..

This particular database only has one user.

Large database or databases or small. Nothing over 15Mb

3. How are you fixing the problem or getting around the problem?

Eventually the problem goes away, but in the meantime I have changed the
startup option to display a form that has no OnLoad code - the original form
counted records in the data entry tables and in any files on the AS/400 that
were waiting to be updated. On an earlier occasion, it was the "Generate
Invoice" option that caused the problem, but if I used one of the enquiry
options first, then it worked.

4. Do you ever Compact the database(s)? (Re-organize, repair, clean out
the
deleted records, etc)

Yes - but not on a regular basis

5. Is the Database(s) being updated heavily or are they more read-only?

Probably less than 500 new records per day

6. Have you searched the Discussions for the error message you are
receiving? What is the specific error message? Does access shut down?

I am just doing that now.
The error is "Microsoft Access has encountered a problem and must close"

It would be more helpful in trying to understand the problem if the group
knew some of the answers to the questions I have asked.

Thanks,
Steve

Steve

I have inserted answers immediately below your questions.

Regards

Peter

 

[Peter Kinsman]

I have just changed the startup form to the one that was causing the
problems this morning and it works fine - but the internet is running much
faster now. I am a remote user, but the person who reported the problem
initially is local.

Peter

 

[Steven Chicago,Illinois]

Peter,

Try searching for "access closing" in the access database general
questions area and there you should find "Microsoft access closing after
problem encountered" 3/26/2006. In the Access Database Forms section you will
find "Access 2000 closing" 3/14/2006. Both mention some good ideas to know.

Important :The "Name AutoCorrect options" should be turned off.

You mentioned it could be a linking problem. If you have moved the database
or parts of it or other databases that it links to, you might want to go in
and do a re-fresh the links.

I also wonder if you have any data fields that are defined as yes or no. I
had a problem where Access got mad at me because I didn't have valid data in
the data field for a yes/no field. So if your importing data from other
systems, do you run edits on the data before updating the new data to your
Master Table(s)? I try to import to a temp table and then run a append query
to update the data to the master table. But making sure numeric is numeric
and yes/no fields are not Null, but instead contain valid data would be a
place to look.

The code you took out from the OnLoad of your form, try putting it in a
button and run it manually on the form. Does it cause the shut down? Try
narrowing things down to the spot where it (access) gets mad and causes the
shut down.

I am running access 2003 too. I also think you should make sure all your
references are ok. That last discussion "access 2000 closing", I think
mentions checking your references, and making sure your using all the current
updates for access 2003 and your operating system. Make sure you check the
references on your users's PC too. I found one user of mine kept corrupting
the database, because she was missing a reference in the VBA modules.

Hope that helps you get closer to the source of the problem,
Steve

 

[Peter Kinsman]

Steve

Many thanks for your help. As I said, the problem has gone away again, but
it is always useful to be prepared for when it reappears. I do not
understand what you mean by the "access database general questions area".

Cheers

Peter

 

[Steven Chicago,Illinois]

Peter,

Sorry this is a week late in getting back to your question. I just got
back in town.

"access database general questions area"

There are 12 sub-groups or areas of the access discussion group. Your
question was posted in the general questions area. There is also a New Users,
design,...Database Security areas.
When I search for a key word or words it seems to only search in the
sub-group (area) that I am pointing to. I have found that you need to search
each area to be sure that you didn't miss a discussion that had your key
word(s) in its text.
I hope that answers your question about what I as saying.
Steve

 

[John W. Vinson]

When I search for a key word or words it seems to only search in the
sub-group (area) that I am pointing to. I have found that you need to search
each area to be sure that you didn't miss a discussion that had your key
word(s) in its text.

The webpage's search mechanism is flaky to the point of being broken. You may
have better luck going to http://groups.google.com, using Advanced Search, and
searching microsoft.public.access.* to span all the groups.

Alas, Google Groups has shown some major flakiness too...

John W. Vinson [MVP]

 

[Steven Chicago,Illinois]

John,

Thanks for your Help. I will try it.

Steve