473,320 Members | 2,029 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Access "not enough memory" - error 3183

JamieHowarth0
533 Expert 512MB
Hi folks,

Got a massive headache. I'm working as a contractor on a project for a SAM company and they are using an Access database with a particular query to extrat information to import from a DB into Visio.

The query is incredibly lengthy and would take too long to remove company-specific info from so I will keep this brief.
The query runs fine on the database when it is used locally on my machine (Acer Aspire 5003WLMi, 1.8GHz AMD Turion ML-32 processor, 512MB RAM, 60GB HDD and WinXP SP2) but when used on the company's machines (HP DX2250, 512MB RAM, 160GB HDD, and AMD Athlon 64-bit 3800+ - around 2.0GHz) the Jet 4.0 engine (as the DB uses linked tables) creates a TMP file that hits 2GB before coming up with an error of "not enough memory on temporary disk".

I have checked:
yet I am STILL getting problems.

If anyone has any ideas on how to fix this then it would be so much appreciated.

Many thanks in advance,

medicineworker
Oct 15 '07 #1
10 18403
nico5038
3,080 Expert 2GB
Did you check where Office has located the temporary files?
I ran once in trouble running my .mdb on a D: drive, but being low on space on the C: drive (less then 150Mb) I got this error....

Nic;o)
Oct 15 '07 #2
JamieHowarth0
533 Expert 512MB
Hi nico,

Have checked, MDB is running on C: drive and temp is located in C:\Documents and Settings\%Logged on User%\Local Settings\Temp.
I have checked read/write perms and all is fine there.

I understand that Access will not deal in any data that is larger than 2GB. The TMP file that is being created goes all the way up to 2GB which suggests (I think) that the Jet ODBC driver is leaking something (as the query runs absolutely fine on my machine with no problems).

The only substantial difference I have noticed between the machines is this: I have SQL Server 2005 Express installed, which colleagues have suggested might fix the (probably broken) drivers, and I also have Jet 3.0 and 3.5 as well as 4.0 (the HP machines only have Jet 4.0 and no previous versions). Could it be something to do with backward-compatibility (all Access DBs that use linked tables are in Access 2000 format)?

Many thanks in advance,

medicineworker
Oct 16 '07 #3
JamieHowarth0
533 Expert 512MB
Addenum - have converted databases to Access 2003 format and still no luck, getting CPU spikes in the region of 70 - 100%. My manager says our PCs should still be under warranty... lmao.

Any last-minute suggestions would be appreciated.

medicineworker
Oct 16 '07 #4
Scott Price
1,384 Expert 1GB
What Office service pack do you have installed on the affected computer? This is Access service pack that I'm asking about. There are some significant issues apparently with using SP3 for Office/Access 2003. Since it runs fine on your computer and not on the other, I'd be inclined to suspect something like that.

See here: http://allenbrowne.com/tips.html

Regards,
Scott
Oct 16 '07 #5
JamieHowarth0
533 Expert 512MB
Hi Scott,

Both machines (mine, which works, and theirs, which doesn't) are running identical copies of Office 2003 with Service Pack 3.

Hope it helps narrow things down further!

medicineworker
Oct 16 '07 #6
Scott Price
1,384 Expert 1GB
Are you both working with the exact same copy of the database? If it's a front-end/back-end situation, have you checked to see that you are, in fact, running the very same version of the front-end?

Also, check to make sure that the version of the front-end they are running hasn't been adapted in some other way that might be affecting the query indirectly...

If you are absolutely sure that there are no software differences between the Access installations and the database versions, then we'll have to look outside Access/Office for possible problems.

Regards,
Scott
Oct 16 '07 #7
nico5038
3,080 Expert 2GB
Hmm, did you consider to change the query in a Pass through query.
It will require a re-write in the original database's native SQL, but all space problems will be solved as the query is processed by the original backend database and only the result is passed back...

Just check the Access helpfile on the Pass through subject.

Nic;o)
Oct 16 '07 #8
JamieHowarth0
533 Expert 512MB
FINALLY IT WORKS!

Discovered problems in the query where it was retrieving data from the tables but had missed out the INNER JOIN statements - hence opening a billion different tables without reference points!

My day is finally stress-free!!!!!!!! :-D :-D :-D

medicineworker

P.S. Thanks to Nic for the idea but as you can now tell by my ecstatic response, it's now sorted. I can go home and SLEEP..... |-)
Oct 16 '07 #9
Scott Price
1,384 Expert 1GB
Glad you got it to work!

Thanks for posting back with what was wrong also.

Regards,
Scott
Oct 16 '07 #10
JamieHowarth0
533 Expert 512MB
We finally found out the meat of the problem, so to speak.

Having copied the DB and structures for our new client project, I deleted all the client-specific data from the DB structure so I could then start from scratch.
Apparently, Access has a (rather annoying) habit of destroying relationships when a table with relationships is emptied.

So the trick is: delete all but one row to use as padding to maintain the relationship references, then when new data is added, delete the padding row!

medicineworker
Oct 19 '07 #11

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Snake Djip | last post by:
Hi, I have a problem with a home-made DLL used in an ASP environment. It is coded in VB6, apartment-threaded. The DLL returns a binary PNG stream (an image). I use it with ASP's...
289
by: napi | last post by:
I think you would agree with me that a C compiler that directly produces Java Byte Code to be run on any JVM is something that is missing to software programmers so far. With such a tool one could...
2
by: webspinner | last post by:
I'm trying to develop a web service using C# and everytime I try to instantiate a NotesSession object like so: m_session = new NotesSessionClass(); the object throws an exception with the...
2
by: WJScott69 | last post by:
C# - CSharp - WIN32 - WMI Progamming Issues with NT4 (Out of Memory) Hello, I am trying to inquire on servers ranging from Windows NT4 SP6a+ to Windows 2000-2003 I have the program working...
3
by: Mark | last post by:
Hello, Recently I have not been able to open an asp.net page in MDE's web from designer. I recieve the following error: "The file failed to load in the web from designer. Please correct the...
7
by: needin4mation | last post by:
Hi, I have an Access 2002 - 2003 database. I am using Access 2003. Whenever I link an image all it shows is the filename. Not the image. Other versions of Access can link the image just fine. ...
3
by: news.microsoft.com | last post by:
Who knows what it means when a Windows XP Pro SP2 produces a transient error window from aspnet_state.exe saying "instruction at reference to memory at . memory could not be read." every time it...
2
by: =?Utf-8?B?UmFscGggSQ==?= | last post by:
OK, Dell inspirion 9300 - 100 gb hd partitioned into 3 drives C: OS 10 gb D: Programs 20 gb E: Data 70 GB Page Files 0 on C: 4092 on D: 3070 on E:
5
by: Mahendra Kumar Kutare | last post by:
I am trying to implement a webserver with boss-worker model thread pool implementation - I have a header declaration threadpool.h as - typedef struct threadpool_work { void (*routine) ();...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.