question

Dmar-9578 avatar image
0 Votes"
Dmar-9578 asked KenSheridan-7466 answered

Access crashes when using find and replace on a column

Access has been crashing on users when using Find and Replace tool. I can replicate the issue on multiple user's machine's and attempted to resolve the issue by conducting a Repair, Uninstall and Reinstall. I also removed Office registry keys to check if the issue will resolve with no success. I also ran the program as admin with no success. There is one user that does not experience Access crashing when performing a Find and Replace and verified he is using the same version of Access as everyone else. Below is the following error I found within event viewer.

Faulting application name: MSACCESS.EXE, version: 16.0.14430.20306, time stamp: 0x6164b612
Faulting module name: MSACCESS.EXE, version: 16.0.14430.20306, time stamp: 0x6164b612
Exception code: 0xc0000005
Fault offset: 0x00000000007a6f95
Faulting process id: 0x37d0
Faulting application start time: 0x01d7cc1209260c8c
Faulting application path: C:\Program Files\Microsoft Office\Root\Office16\MSACCESS.EXE
Faulting module path: C:\Program Files\Microsoft Office\Root\Office16\MSACCESS.EXE
Report Id: a8858a79-25b2-4f12-8190-f27f1899b50d
Faulting package full name:
Faulting package-relative application ID:

office-access-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KenSheridan-7466 avatar image
0 Votes"
KenSheridan-7466 answered

I think we might be on the road to Dublin here. While 'find and replace' is a cheap and cheerful way of updating data, executing an UPDATE statement is the usual approach in a developed relational database application. If this is a frequent requirement you can build a user-friendly interface by which the users can build and execute a statement to update values in a table. However, the fact that you need to do this does make me wonder about the validity of your table designs. Perhaps you could clarify the context in which 'find and replace' is being used.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.