Access 2007 supporting more than 2GB files?

[Jan]

Excel 2007 has 1 million rows. Any capacity improvements in Access,
like no more 2GB limit on MDB files?

 

[Guest]

Why would you ever want more than 2GB of data in an Access database?????

Damian.

 

[Brendan Reynolds]

There is no change in this regard. As in earlier versions, an MDB can not
exceed 2GB, but you can link to tables stored in a server database such as
SQL Server if you have more than 2GB of data.

SQL Server 2005 Express Edition, the free edition of SQL Server 2005 that
replaces MSDE, can store up to 4GB.

 

[Guest]

So, any fixes to transaction handling, or are transactions
still broken when working with linked SQL Server tables?

(david)

 

[Rick Brandt]

So, any fixes to transaction handling, or are transactions
still broken when working with linked SQL Server tables?

Access has always had two groups purchasing it. The first group is "Home/Office
Users" who use it like Word and Excel to help them out in their work and to
throw together small single user databases. The second group is "Developers"
who use it to make real applications for other people to use in a professional
environment.

The vast majority of the changes in Access in the last few versions has been
targeted almost exclusively at the first group. It is all about tweaking the
GUI, eye candy, and making it ever easier to point and click your way to a truly
horrible database application. Fixing bugs and improving things for the
developer group is not "sexy" and doesn't have the marketing appeal so it just
doesn't get any attention.

I suspect that MS thinks that making Access everything it could be for the
development community would undercut the all-dot-net strategy that they are
pursuing. It is simply not in their strategic vision to have a best in class
desktop development tool out there (even if it is their own product).

 

[Tony Toews]

Excel 2007 has 1 million rows. Any capacity improvements in Access,
like no more 2GB limit on MDB files?

Personally I think MS was nuts to allow a million rows in Excel.

Well, ok, maybe for data analysis and such. Although I wonder about
performance.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[aaron.kempf]

then they need to spin it off into it's own company

Access has more eyeballs than VB.net does

-Aaron

 

[aaron.kempf]

great analysis though bro

-Aaron

Access has always had two groups purchasing it. The first group is "Home/Office
Users" who use it like Word and Excel to help them out in their work and to
throw together small single user databases. The second group is "Developers"
who use it to make real applications for other people to use in a professional
environment.

The vast majority of the changes in Access in the last few versions has been
targeted almost exclusively at the first group. It is all about tweaking the
GUI, eye candy, and making it ever easier to point and click your way to a truly
horrible database application. Fixing bugs and improving things for the
developer group is not "sexy" and doesn't have the marketing appeal so it just
doesn't get any attention.

I suspect that MS thinks that making Access everything it could be for the
development community would undercut the all-dot-net strategy that they are
pursuing. It is simply not in their strategic vision to have a best in class
desktop development tool out there (even if it is their own product).