Specific Values List Missing

[David]

Hi, I am experimenting with using MS Access 2007 as a front end to a MySQL
database. I want the DB to be able to be seen over the internet, hence the
use of MySQL but I want the handy filtering features for users which MS
Access provides.

I'm noticing a difference with filtering behaviour depending on whether the
table is in the current MS Access DB or a linked one in MySQL.

If you have a table (or a form in datasheet view) you can left click at the
top of the column where the arrow is and it will drop down with a list of
filters available depending on the data type of the field. So if you click
on a date field you get all the date filters.

Now normally you also get a list of specific values. So that you can check
and uncheck specific values or choose "Select All". But I don't get these
specific values check boxes with the linked tables. Or forms based on the
linked tables.

Is this correct behaviour? Or am I seeing something strange? My users would
like to use all of the filtering facilities available and they do use the
specific values check boxes.

Any help appreciated.

David

 

[Clifford Bass]

Hi David,

Office button, Access Options button, Current Database section, Filter
lookup options for [your database name] subsection. Make sure the ODBC
fields check box is checked.

Clifford Bass