Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
slimjen
Yak Posting Veteran
61 Posts |
 Posted - 2012-07-17 : 10:40:30
|
| 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 subreportI 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
52326 Posts |
Posted - 2012-07-17 : 10:47:52
|
| might be better of posting this in access form as question seems to be related to access------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
slimjen
Yak Posting Veteran
61 Posts |
Posted - 2012-07-17 : 11:07:30
|
| Ok Will do Thanks |
|
|
|
|
|
|
pass thru qry