DataBase - Sorting & Grouping limited on A2007 report based on pass-through

I am designing a report based on a totals query, which is in turn based
on a pass-through query (SQL Server 2005).

For some reason design view in Access 2007 does not permit sorting &
grouping on some of the columns.  The missing columns are simple text
Group By columns in the datasource, similar to others that are can be
selected as Group by columns in the report.  They just are not shown as
choices in "Add a group" within Group & Sort.

Any ideas on the reason?

  brucedodds2 replied to brucedodds2

The reason was that Access was identifying the missing columns as memo
rather than text.

Roger Jennings on Access / Sharepoint DataBase http: / / www.quepublishing.com / articles / article.aspx?p = 1606238 I was very dismayed this article, is it makes it pretty clear that in-house hosting of your Sharepoint server with Access Services to support browser-based Access apps is something only large companies will be able to afford, because the pricing and licensing for the Enterprise version is very, very steep. The alternative is hosted Sharepoint / Access Services, and the costs do not seem terribly high. It seems to me that the pricing is upside-down. Big enterprises do not want to deploy Access apps in the browser - - they will build their own .NET apps, browser-based or not 2010 does not really save them money (because of the 64-bit requirements of Sharepoint Server 2010, it could vastly increase those costs for organizations with legacy hardware). The features of Access 2010 used in conjunction with Sharepoint 2010 seem to me to be most compelling for

SQL query slow DataBase Hi In the code below I found that it takes 1.3 seconds to load. There is a possible reason, it reads from a local MDB file (access), and it reads from some 270000 rows (result some 15-20 rows, where the highest are counted 150000, 50000, 40000, 26000, remaining are 100's). This is probably more Access that Visual Studio, though - is there a way to split it up or cancel the query? And can I read this faster? string sql = EquipmentID(Equipment) + StartDate.ToOADate().ToString(FloatFormat, myCulture) + EndDate.ToOADate().ToString(FloatFormat, myCulture); sql + = " group by event_id, name"; _Log("Calc thread #2"); OleDbCommand com = new OleDbCommand(sql, con); _Log("Calc thread #3"); From #2 to #3 it takes 1.3 seconds. Remaing code takes less that 0.1 second. So the query is what slows it down. Access Discussions SQL Server (1) Linson Unlike Albert D. Kallal (1) MySQL (1) Windows Server 2003 (1) Visual

Access to SQLServer GCE DataBase I = 92m trying to step up from being a decent Access Programmer, to including SQLServer in my repertoire and am running into a conceptual design problem component would be = 93awaiting repair = 94 How do I pass this status date from the Access front end to the SQLServer so I can make a view that includes the status on the desired status date? I know I can pull all the data to the Access front end and do the processing there, but that seems wildly inefficient! Note I am thousands of components and hundreds of thousands of events if that makes any difference. Thanks Access Discussions SQL Server (1) Larry Linson Microsoft Office Access (1) SharePoint (1) InfoPath (1) Microsoft SQL Server (1) Access 2007 (1) Informix (1) Office

MCITP DBA proof DataBase https: / / mcp.microsoft.com / authenticate / validatemcp.aspx transcript: 944364 AccessCode: helloworld Access Discussions SQL Server 2008 R2 (1) SQL Server 2008 (1) SQL Server 2005 (1) Microsoft SQL Server Reporting Services (1) Regards Larry Linson Microsoft Office Access (1) Bing

Cannot link to SQL server DataBase Can any of you guys help? I am new to using SQL Server. I have a database that I wish to upsize from Access to put the back end on a server, and use Access as a front-end. However, I am stuck at the very first stage - I cannot link Access to the SQL server. I am using SQL Server Management Studio on a single computer