SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 pass thru qry		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

slimjen
Yak Posting Veteran

61 Posts
Posted - 07/17/2012 :  10:40:30  Show Profile  Reply with Quote
Hi all, using access 2003 front end sql server 2008 back end. When opening a form with a subform based on a pass thru query, I am getting the following error:

You can't use a pass-through query or a non-fixed-column crosstab query as a record source for a subform or subreport

I am using the pass thru because subforms based on regular access query is slow since upsizing to sql server and thought pass thru would be faster. I've search the internet but haven't come accross any solutions. Wondering if anyone has a solution that I may try to get this running.
Thanks

visakh16
Very Important crosS Applying yaK Herder

India
47173 Posts
Posted - 07/17/2012 :  10:47:52  Show Profile  Reply with Quote
might be better of posting this in access form as question seems to be related to access

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

slimjen
Yak Posting Veteran

61 Posts
Posted - 07/17/2012 :  11:07:30  Show Profile  Reply with Quote
Ok Will do Thanks
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000