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.
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
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).
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
