MS Access max usable memory

[Endeavor]

Hi All,
We're running a heavy duty MS Access/Sql Server app that processes a few million transactions per night in batch mode.
We're upgrading our server hardware to an IBM x345 with 8GB of RAM for performance reasons.
The new server will be upgraded to Windows 2k advanced server, and the database to Sql Server Enterprise edition to take advantage of > 4GB memory.
Can anyone tell me how much memory MS Access 2k can actually use? I searched the MS knowledge base, but couldn't find this information.
Thanks,
Bill

 

[lupins46]

I don't know either, but I don't see why the memory on the server is relevant to Access unless it is being used by a user sitting at the server.

 

[ocan]

From Microsoft webpage:

Attribute Maximum
Microsoft Access database (.mdb)

File size 2 gigabytes minus the space needed for system objects (system object: Database objects that are defined by the system, such as the table MSysIndexes, or by the user. You can create a system object by naming the object with USys as the first four characters in the object name.).
Number of objects in a database 32,768
Modules (including forms and reports with the HasModule property set to True) 1,000
Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255

 

[Endeavor]

As I mentioned, this is running in BATCH mode on the server, there are no clients involved.
I'm looking for how much memory Access can utilize.
Thx.

 

[Philly44]

I really don't think there is a "maximum". The amount of memory it uses is dependent on what its doing, how it was programmed, how often maintenance work is done on it, the list goes on...

 

[Ed2020]

If you are talking about RAM then my guess is the maximum amount would be the same as any other 32 bit application - 4GB (or 2^32).

Access will only utilise the RAM on the machine it is running on.

Ed Metcalfe.

Please do not feed the trolls.....