Access crashes when doing Find & Replace

[OdieDenCO]

I have 2 users experiencing Db crashes when they do a simple Find & Replace
(Ctrl F) on a form. Each user is searching for different records. The search
will display 3 or 4 records before crashing. No other user is having the
problem. One user has version 2002 SP3 the other version 2003 SP2. The Db is
version 2002 about 17 MB in size. I’ve rebuilt the main table used in the
search and another large child table, with no results. Anybody seen this
before?

 

[Jerry Whittle]

Are all the users on the same database or is the database split with each
user having their own Front End?

 

[OdieDenCO]

Same Db on the network.

Are all the users on the same database or is the database split with each
user having their own Front End?

 

[Jerry Whittle]

1. Split the database into a front end with the forms, reports, etc., and a
back end with just the tables. Each user gets a copy of the FE on their
computer. Access comes with a Database Splitter tool.

2. Under Tools, Options, Advanced tab make sure that the Default Open Mode
is Shared and Default Record Locking is Edited Record.

3. Make sure that all users have full privileges to the network folder
holding the database file. They all need Read, Write, Create, and Delete for
the entire folder.

4. Backup the database frequently to either your PC, tape, or another
network drive on a different hard drive. Nothing beats a current backup when
things go bad.

5. To prevent database corruption problems see if your network people will
run a sniffer to look for bad packets and other network problems. If there is
a problem, Access will fall victum to it. A sniffer is somewhat expensive.

6. Do a Ctrl + g to bring up the VBA window. Go up to Debug, Compile (the
database name). If it isn't grayed out, compile the database. See if there
are any error messages and fix them. Save.