ACCESS FEED: Re: [MS_AccessPros] Does Access 2010's limits increase with SQL Server on BackEnd

Senin, 03 Februari 2014

Re: [MS_AccessPros] Does Access 2010's limits increase with SQL Server on BackEnd

Tim-

Surely the "cheat sheet" info breaks down into categories. Use subforms or subreports for the categories with the main company info on the outer form or report. I've built this sort of report before with close to 1,000 data items in the final product.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Feb 3, 2014, at 10:49 PM, <timdbui@gmail.com> <timdbui@gmail.com> wrote:

Hi Duane,

Thanks for your reply! My real intention was to create a form and a report that draw about 400 pieces of data from a query (which pulls data from many other queries). For now, what I see is an Access 2010 query can only handle about 255 fields, which means my form or reports can only contains 255 fields or less. I am trying to find a way to put more data on a report so that the users can have all of the information they need in one spot. For example, I wanted to create a "cheat sheet" that contains all important financial data of a company (Income Statement, Balance Sheet, and Cash Flow Statement) going back 10 years. With 255 field limitation. I can only have 25 row of data for the 10 years period.

For now, as work around, created several forms or several reports with each has fewer fields. I just thought SQL Server would give me more features.

From your email, it seems that since I use Access, it is the bottle neck.

One last question, do you know if there is anything out there that could replace Access as the Front End? I like Access so much because it is so easy to use.

Thanks again, Duane!

Tim