We help IT Professionals succeed at work.

Microsoft Access query - dropdown filter problem

3,304 Views
Last Modified: 2014-09-09
I have recently converted a database to SQL Server. Now some of the columns in a query do not give the option to filter on a particular value. I have not explained this very well, so I recommend looking at the screenshot attached. This displays the dropdown filter that I require, but it does not happen for every field, and I can't understand why.
EE-screenshot.docx
Comment
Watch Question

ste5anSenior Developer
CERTIFIED EXPERT

Commented:
Please post screenshots as images. Either embed them in your message using the image icon in the message toolbar or attach the image as image. Don't warp it in a container.

Thus just a guess: The normal problem is that Access can only filter text columns, when they contain less then 256 characters.

Please post the table DDL.

Author

Commented:
Don't know how to do any of those things. It's attached to my question - you should be able to download it. However I think you understand my problem, so the screenshot won't really help.

My point is that it works when the tables are held in an Access back end database, but when they are in SQL Server, it doesn't work.  Are there any obvious solutions?
ste5anSenior Developer
CERTIFIED EXPERT

Commented:
Not without further details.

p.s.
EE message toolbar
Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks for your reply.

My point is that these filters all work on the Access back end database, but not on the SQL Server database, as per my previous post. However, I will check the pages that you reference. It just seems odd that it used to work, but does not work any longer.
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
I've requested that this question be deleted for the following reason:

no satisfactory answer
CERTIFIED EXPERT
Top Expert 2012

Commented:
no satisfactory answer
Re-opening the question to allow the author to close the question more appropriately as they were specifically told that they cannot use Text Filters with MS SQL Server and therefore this question falls under The experts told me “you can not do that”. What do I do now?
CERTIFIED EXPERT
Top Expert 2012

Commented:
The following comments should be awarded points:  http:#a40269934 and http:#a40269958
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.