Access queries keep changing

  widdy 08:17 25 Sep 2005

I have a database with just one table consisting of names addresses, phone nos etc, about 20 fields.
All queries work from a switchboard. if i look for a person by name my criteria is " Like [enter surname] & "*" " which allows me to look using just the first few letters. this works fine a few times then suddenly will start to go in a loop and ask me to enter surname again up to 3 times.
If i rewrite the criteria and save it, all is well to start and then it loops again.
Any thoughts

  widdy 08:03 26 Sep 2005


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017