Search Query crashing database

[Hamm]

Hi



I have a weird issue with a search query that is crashing the database. i have multiple unbound text boxes which are used to search different fields and when i type into them the database crashes and forces me to restart. interstingly though, one of the boxes works but i cant see any reason for this to work but not the others. Also, when i ope VB editor and close it again, all the search boxes work.

has anyone experienced anything like this before?

thanks
Hamm

[Missinglinq]

This type of thing comes under what I call Strange, Odd and Curious Behavior, and S/O/C/B, especially when coupled with the phrase 'sometimes it does/sometimes it doesn't,' usually translates into corruption, in one form or another.

The fact that you're seeing this on multiple-controls makes it sound as if it's corruption of the Form, even worse, corruption of the entire app!

The first thing to attempt, for this type of corruption, is to create a new, blank file and import everything into it. Only takes a minute or two to create and check out, and if it doesn't work you haven't really lost anything! And, amazingly, it does frequently work!

Linq ;0)>

[Hamm]

Hi Linq

Can you tell me exactly how i create a new file and import everything. there are a lot of reports, queries and forms in this together with macros. i assume everything can be imported?

thanks
Hamm

[Missinglinq]

From inside Access:

1. Click on the 'New' or use <Control> + <N>
2. Click on Create
3. Go to top of the Ribbon and click on External Data
4. Under that click on the Access Icon
5. Click on Browse
6. Find your errant Database File
7. Click OK
8. Tab by tab, go thru Tables, Queries, Forms, etc, clicking on 'Select All' each time
9. When done selecting all Objects, click on OK

You should now be set. If everything now works, delete the old file and rename the new one as the old.

Linq ;0)>

[Hamm]

Thanks Linq

Worked a treat. Lets hope I dont get any more SOCBs

[Missinglinq]

Glad we could help!

Here's a very good article, by Allen Browne, on preventing corruption. It's well worth a read:

http://allenbrowne.com/ser-25.html

Linq ;0)>