Access flaky

[MarianneZ]

I'm a newbie but I've been developing and coding in Access for 3+ months now.
And generally successfully.

BUT as I work, Access crashes about 10 times a day. Maybe more. I decompile
and continue, then get another crash.

After some research, I recommended Access for this application. But now I'm
worried that these frequent crashes will occur not just during development
but during regular usage.

Does anybody else have this problem?

 

[Jerry Whittle]

A lot depends on what you mean by "crash". I seldom get any, much less
frequent, crashes during development or in production.

It could be a corruption issue.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[Gina Whipp]

MarianneZ,

I have not experienced that problem (except on a machine that croaked) so
perhaps a little more information ight help pinpoint the problem.

1. Windows version?
2. Access version?
3. Are you designing reports and do not have a default printer installed in
Windows?
4. If you are not designing reports is this happening when you are doing a
specific form or forms in general?
5. Any error messages?
6. Have you declared all variables?

I would also try creating a new database and importing all the objects into
it. Sometimes things may get a little wonky in the designing stage and a
new database is needed. Hmmm, by wonky I mean you have add/updated/deleted
so many controls and objects that you have come close to Access' lifetime
controls and new database gives you a clean 'file'.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Dorian]

What version? Do you have all service packs installed? Tell us what message
you get when Access 'crashes'. What are you doing at the time? There is
usually a logical reason for and failure. Until you resolve this, make
regular backups. Compact and repair and database under active development
once per day.
I've been using Access (2003 version at moment) for 10 years and have found
it to be pretty reliable provided it is used properly.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[MarianneZ]

Thanks to all who replied. I should have said I'm using Windows XP, version
2002, with Service Pack 3. And Access 2007. I think I'm up-to-date on all,
uh, updates. Unless there was a recent (last 2 weeks) fix for Access. One
peculiarity: I have Microsoft Office 2003 on this computer. Only Access is
2007.

As a quick and easy step, I tried Gina's suggestion of importing everything
into a new database. Having successfully imported all tables, forms, reports,
and queries, I made the very minor change of moving 1 field in 1 table. Then
I tried to open a form. The usual crash happened. That is, a box pops up,
saying "Microsoft Office Access has encountered an error and needs to
close.... I send a report to Microsoft, and the database is repaired and
reopened, first saving a backup.

A while back Microsoft noticed all the error reports and sent me a suite of
tests. Passed 'em all, no problem.

Given that his has been a learning experience for me, there are a lot of
commented out lines, and not every module has Option Explicit. So I expect
there might be some undefined variables.

I will investigate the other suggestions.

MarianneZ, having arisen from her sick bed

 

[Gina Whipp]

MarianneZ,

When you get chance if Microsoft sent you a link with things to try you
might want to post it here. It ight help lead to what the problem is.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm