Re: The best elegant solution to override 65k rows limit in a ***

sprocs and views ARE written with Access. It is called ACCESS DATA
PROJECTS. MDB is friggin dead.. SQL Server has taken over the world.

I still disagree with your understanding of the popularity of Access.
I dont think that there is a single company in the nation with more
than 5,000 employees that doesnt have Access installed on SOME of their
desktops.

Over the past 7 years; I have been at a half dozen companies with over
ONE HUNDRED access databases.

That is a lot of reports...

Access isn't aimed for IT people. Access is aimed at end users.

Having end users create views and sprocs-- that is not as bad of a deal
as it sounds. I learned to write queries in Access after an hours'
worth of training. Not that big of a deal.

I just strongly disagree with your understanding of Access on the
desktop. And even if your end users dont have Access; they can still
use the Access Runtime if ONE person at the company buys Office 2000
Developers edition.. I'm not sure of the licensing with newer versions
of office; I just dont have time to deal with companies that aren't
willing to invest in their workers.

and just for the record; cutting and pasting data between worksheets---
running macros--- that is NOT an automated manner.

basing your reports on queries that you store on the SERVER --- as is
FREE with MSDE and Access Data Projects-- this is the best way to run a
business. Since you can change a sproc in one place instead of
changing 100 MDB queries.. or instead of changing 1,000 spreadsheets.

I just dont see the logic in usgin Excel at all.

It is absolutely a disease. You guys are a disgrace to your companies;
modernize, or be kicked to the curb.

.