The pattern string is invalid...?

[dwilliams]

Hi,
I have created an Access database and imported a load of data from an Excel spreadsheet. All fields are set to TEXT except a YES/NO field, a MEMO field and of course the ID field.

I have been searching my database most of today updating records as required by using the SEARCH function at the bottom of my form. All of a sudden I now get the error message "The pattern string is invalid" whenever I type something in the search box.

I have checked out the last record I changed but there appears to be no obvious type cast faults.

What's going on?

Help much appreciated

Thanks

Dave

 

[dwilliams]

I rebooted my computer and it's gone away now.

Huh!

 

[SydneyGeek]

Run a Compact and Repair (Tools > Database Utilities > Compact and Repair, or for 2007, Home button > Manage > Compact and Repair) in case you have some corruption lurking, or your database is getting large, or you haven't done a C&R for a while.

Denis

 

[dwilliams]

Thank you. Good advice indeed.

DW