Access limitations

[JoeA2006]

Is there a limit on the size of an Access file or number of objects?

 

[Charles E. Vopicka]

an access file can only be 2gb. at which point it seems to crash
violently. i think that you can have as many things in the database as
you want as long as you are under the 2gb ceiling.


i hear this limit is a 32bit addressing issue. so when 64bit hits main
stream shouldn't be a problem anymore.

 

[tina]

recommend you open Access, open Help, and do a search on "specifications" to
get correct information.

hth

 

[Charles E. Vopicka]

sorry the only one of the limits i have had to deal with is the 2gb
limit. i assumed the rest from observation.

 

[Tony Toews]

i hear this limit is a 32bit addressing issue. so when 64bit hits main
stream shouldn't be a problem anymore.

I'm pretty sure the 2 Gb is an Access/Jet limitation.

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

 

[Arvin Meyer [MVP]]

I'm pretty sure the 2 Gb is an Access/Jet limitation.

It is an Access issue. The limitation is set by Microsoft to help ensure
data integrity. The Exchange/Jet database is 16 GB for versions < 2003 and
75GB for version 2003. It is a different type of Jet, but works somewhat
similarly.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access