Access Crashes Hard

S

StevenF

In a mutiuser front and back end database I have deployed, Access will crash
hard (no warnings or backups) when someone is scrolling through a large form,
or two or more people are using the same form. I have record level locking
set up.

Any Ideas?
 
R

Roger Carlson

Do you mean that the form itself is large (ie there are dozens of controls
on it) or that the Record Source of the form is a large dataset? If the
latter, I suggest you might want to modify your application to reduce the
RecordSource of your form to a single record. This is different development
mindset than filling the form with the whole table, but you have to start
thinking this way when your tables get very large.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ImproveFormPerformance.mdb" which illustrates one method of
doing this. It is by no means the only way, but it does illustrate how you
can present just a single requested record to the user rather the the whole
dataset.

Another place to find out more about this concept is: "Microsoft Access
Developer's Guide to SQL Server" by Mary Chipman and Andy Baron. Even if
you're not using SQL Server, some of their development techniques can be
used profitably with a Jet database.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
S

StevenF

The form itself is large, with a tab control and subforms. I have queried
and filtered the data down to the minimum needed. What is strange is the
crash. I have never seen Access drop so quickly without warning.
 
A

Albert D.Kallal

StevenF said:
In a mutiuser front and back end database I have deployed,
Click to expand...

In the above, I assume a Front end is distributed to each user's PC...right?
(often people split, but still put the front end on the server..and that
will not work).

So, check the above.....

Next, I would try distributed a mde to each user...does that work?

If you not placed the front end on each pc, then you can read the following,
as it explains why you do this, and why it is a issue of reliability.

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm
 
A

Albert D.Kallal

Some have reported that when you have a form->sub form, and you do NOT
include the link master/child controls as control, then you can get a crash.

I never experienced the above, but one MVP has mentioned this as a
"bug"/problem.

I have also seen a case where the back end data was bad, and it was causing
the front end to go south.

Since you have clarified how you got your setup, (sounds like you got things
good and correct), you could try a mde, and see if that helps...

So, at this point, kind of at a loss, but would try the mde idea....
 
Top