memory management

Whan I have a user who uses memory intensive apps like macros in Access, I usually want to max out the memory they have available to use. What is the minimum and maximum settings for a machine with 128 meg? What about one with 256meg? Please explain your answers. Thanks.