acCmdFilterMenu and Remote MS SQL Server

[Alexander Kramer]

I am coding an Access Frontend which uses linked tables from a MS SQL Server
as Datasource.

All Forms are getting their data through complex views, which are being
created within Access.

Now to my Problem:

I have some textfields, where I can apply a Filter by clicking on a button.
The Command behind this is: DoCmd.RunCommand acCmdFilterMenu

Now ... When the Datasource Tables are located in Access 2007 and I click on
this Button, a menu appears and lets me choose between all items available
fopr filter selection.

When the Datasource is located on my SQL Server and I use linked tables via
ODBC and I click on this button, the menu appears but is empty except the
possibility for sorting.

No Items are being shown ... but they surley are in the table ... what am I
doing wrong?
How can I solve this?

 

[Alexander Kramer]

One Thing I found out ...

it has nothing to do with the filterMenu Command ... The problem begins with
the connection to the MS SQL Server because even in the tableview I am not
able to get this Filtermenu ... What must I do, to configure the connection
between Access2007 and MS SQL Server to get this feature?! (click right next

 

[RDub]

Are you linking to Sql Views or directly to the Sql Tables themselves?
What version of Sql Server are you using?

Rdub