Sql Server compatible Syntax...what it means for access

Had a small hicup with an access database which had a nice little filtering system which just stopped working when moving to a more secure workfile.

Found that setting the filter to be [Surname] Like 'A*' was the issue.

It kept changing to using Alike 'A*' in the advanced criteria.

All we had to do was use % instead of * and all was well.

This will work better when we do move the backend to sql server!

Tom Bizannes

Sydney, Australia