Database size limit

[DBAMJA]

Here is just a quick question...I know that with versions 2002 and 2003 and other versions have a file size limit of 2G. Is there such a limit with version 2007? If so, what is it?



[flush]

DBAMJA

It is said that God will give you no more than you can handle. I just wish God didn't have so much faith in me.

 

[Remou]

Here you go:

http://office.microsoft.com/en-us/access/HA100307391033.aspx

 

[DBAMJA]

Thanks. I was hoping that they had changed that but I guess not.



[flush]

DBAMJA

It is said that God will give you no more than you can handle. I just wish God didn't have so much faith in me.

 

[missinglinq]

The fact of the matter is, if you've got a database anywhere near that big, you need to be migrating the back end to something else, like SQL Server or Oracle.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[boblarson]

Of course you can have single table database files all linked together to add to that limit.