Maximum Ram Utilized

[LearningSql]

Hello All --

Simple question on maximum limit for MSAccess 2000 / 20002 / 2003. Is there a limit on how much RAM MS Access can/will use? Or will it consume all RAM available if it needs it?

Any documentation or other threads would be extremely helpful. I've searched to no avail on multiple websites. They only list "minimum" amounts but do not really go into max limits.

Thanks in advance.
PA

 

[SteveR77]

If I am not mistaken MS Access like all other MS applications will attempt to take the amount of RAM that is needs. However the other maximums for Access 2000 and 2002 can be found at the link below.

http://www.databasezone.com/techdocs/acclimit.html

Hope this helps,

Steve