Form Filter with % or *

G

Guest

I have 2 access databases, in one a have to use % and in the other *, where
can i configure to use the same symbol for all databases?
 
A

Arvin Meyer [MVP]

All SQL-Server databases (MSDE engine) use the percent (%) sign as a
wildcard. Access mdb (Jet engine) use the asterisk (*)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter fileds with % or * 3
Access 2003 vs 2010 1
Use a form control value to filter query only if form is loaded. 3
Sub Form shows Chinese symbol and box 12
Record-Locking remains open after closing 0
database didn't build the filter 1
Access Need help in making asset history in my current database. 1
Database locks after running report 8

Top