Solved

Microsoft Access 1GB Memory Limit???

Posted on 2004-03-25
13
3,463 Views
Last Modified: 2007-12-19
Is there a workaround to the Microsoft Access 1GB memory limit? I have a dual pentium xeon machine ... processors each running 1GB each. I can't take the RAM out to test the boundary. Need a workaround.

Thanks for your help.

Matt
0
Comment
Question by:matticus
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +5
13 Comments
 
LVL 34

Expert Comment

by:flavo
ID: 10683253

1 gig for 97, 2gig for 2000 or 2002 +

Use other databases with the data in them, then link them to your main database with forms etc. in it.  You can then use union query’s to join the tables, however, a query cant be bigger than 1gig also.  Type Specification into the help and you’ll get all the spec’s for your version.
0
 
LVL 16

Expert Comment

by:ahmedbahgat
ID: 10683445
do you mean the access file size, not memory size?, the OS is the one that handles the ram and can allocate as much memory as access requires

I think you meant file size, the work around that s to break the database into frontend and backend, the front end will not have ant tables so its size will always be far less than access limit,

the backend will be the issue if you have zillions of records, and the workaround for that is to break the backend into many backends, ie backend1.mdb, backend2.mdb, and so on as you see what make sense, theleink the frontend.mdb to all the tables in all the backend(x).mdb   files, or the best will be to use SQL as backend for the access frontend, if bufget allows


cheers
0
 
LVL 1

Expert Comment

by:chindeep
ID: 10683876
I would add that you should compact and repair the database often to avoid the dreaded bloat.
Select Tools|Database Utilities|Compact and Repair.
Note that this cannot be done to an mde file
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Expert Comment

by:tubelight
ID: 10684160

The limit for access is 2 gig of file size on the DISK for ONE mdb file.

ofcourse remember that this 2 gig is the 'theoretical' limit. Practical limit would be less than that. as a thumbrule-80% 1.6 gig

You are thinking about the RAM, which is not at all an issue in your case. I would imagine average user of access is in the range of 128 to256 megs of RAM and yet happy. sounds like the machine you have, you are far far away from reaching those limits.

If your mdb file is reaching the mentioned limit (1.8gig) then you have to split the mdb into seperate small mdbs and link them together. So virtually you have no limit on the file size also.

If at all you have constraints on the hard drive size (which i seriously doubt) you can split the database into more than one mdb file(s), place differnet mdb files on different machines and link them them together in one mdb.

Splitting the database means moving the tables from one mdb file to another mdb file and linking them together.

if you are using access2.0 (the grandmother times) then your limit on the file size is 1 gig, so start splitting if your mdbs are aproaching 800megs.
0
 
LVL 34

Expert Comment

by:flavo
ID: 10684177
97 also has the 1 gig limit
0
 
LVL 1

Expert Comment

by:sendtojp
ID: 10684940
Don't worry about the 2 or 1 gig limit.  You will never reach that anyway.  If you need to store a picture store a link to it.

-JP
0
 
LVL 18

Expert Comment

by:jmoss111
ID: 10685763
Or just switch to MSDE backend... 2 gig limit
0
 
LVL 1

Author Comment

by:matticus
ID: 10691090
I am not talking about the file size limitation, but a memory boundary similar to the one found in this article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;161255

Is there a way to "trick" a program into only accessing 1GB of RAM?
0
 
LVL 18

Expert Comment

by:jmoss111
ID: 10691571
The trick is in the article attached to the link that you provided. Update to Jet 4.0 then the problem will go away, or thats what Micrisoft says....

SYMPTOMS
You receive an "Out of memory" error when you try to start Microsoft Access on a computer that has 1 gigabyte (GB) or more of random access memory (RAM).


RESOLUTION
To prevent the error, you can use either of the following methods:

Method 1

Run Access on a computer with less than 1 GB of RAM.

Method 2

Install the latest version of the Microsoft Jet Database Engine.
STATUS
Microsoft has confirmed this to be a problem with the Microsoft Jet Database Engine version 3.0 and 3.5. This problem no longer occurs in Microsoft Jet Database Engine version 3.51, which is available from Microsoft Download Center.

0
 
LVL 16

Expert Comment

by:ahmedbahgat
ID: 10693029
matticus,

the link you provided also contains the answer to your problem, did you find that link after you raised your question? if yes then you can ask for a refund of points, I run access 97,2k,xp,2k3, on computers with more than 1 GB of ram and never seen this problem however I always have my os and application updated regularly, that is why I though you meant file size and not ram size as the ram problem is a very rare thing that I have never seen it is a bug and will be fixed by a patch and this is the workaround you need realy


cheers
0
 
LVL 1

Author Comment

by:matticus
ID: 11497506
how do i get a refund?
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 12542262
PAQed, with points refunded (250)

modulo
Community Support Moderator
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Microsoft Access report help 4 38
Access Form - Button Format Issue 13 51
question about a text field with default value 5 31
ISeries Remote Location Route entry 2 28
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question