What is the maximum size of a database in MS Access 2007?

[Guest]

I have been using Access 2000 and restricted by the 2gb maximum size for a
db. Is the size increase in 2007?

 

[Gina Whipp]

Still the same, see
http://office.microsoft.com/en-us/access/HA100307391033.aspx

 

[Guest]

Many thanks - the answer I wasn't looking for!!! Any ideas on how I can
get round this and still use Access. Only reason I want to stay on access is
I know what i am doing and can manage the db using the front end/wizards, etc.

 

[John W. Vinson]

Many thanks - the answer I wasn't looking for!!! Any ideas on how I can
get round this and still use Access. Only reason I want to stay on access is
I know what i am doing and can manage the db using the front end/wizards, etc.

Access makes a very good frontend to SQL/Server, MySQL, DB/2, or any other
ODBC compliant database engine. You'ld just use linked tables, very much like
linking to an Access .mdb backend.

You won't be able (as easily, it can be done) to make table design changes,
but if you're dealing with 2Gbyte of data you hopefully have your table design
pretty solid by now!

One question: are you storing images? Access has been VERY bad at doing so up
until now; A2007 is supposed to handle image data much more compactly (or you
can do what most of us have been doing, and store only a path and filename to
an external graphics file).

John W. Vinson [MVP]

 

[Guest]

What size are you looking for? SQL-Express offers 4Gb and you can use that as
a backend.

 

[Jeff Boyce]

A 'kludge' sometimes mentioned in this newsgroup is to use multiple (large)
Access .mdb files as back-ends, each with less that 2Gb, and link to them
all from your front-end .mdb ... but enforcing referential integrity is out
with this approach.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Tony Toews [MVP]]

I have been using Access 2000 and restricted by the 2gb maximum size for a
db. Is the size increase in 2007?

Storing more than a few hundred Mb of data in an Access MDB is
unusual. What kind of data are you storing?

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/