473,804 Members | 2,148 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

recordset.MoveL ast - "not enough space on temporary device"

Hallo,

Kurzversion: erstellt Access eine volle Kopie der Tabelle, wenn mit
Currentdb.OpenR ecordset("Tabel le") eine Tabelle zum Direktzugriff
geöffnet wird?

Hintergrund: Tabelle 1.25GB, minimaler Code (s.u.) führt zur
Fehlermeldung.

Was ich eigentlich nur brauche: Zugriff datensatzweise. Dafür müsste
rein technisch doch ein minimaler Speicher ungefähr in Größe des
einzelnen Datensatzes ausreichen. Meinetwegen auch 1MB als Puffer.

Läßt sich das irgendwie in Access mit VBA realisieren?

Herzlichen Dank im Voraus!

Marco Loskamp
Hier also der Problemcode:
*************** *************** *************** *************** *************** *************** ****
Sub myUnterProgramm ()
Dim base As DAO.Database
Dim record As DAO.Recordset
Set base = Application.Cur rentDb
Set record = base.OpenRecord set("Tabelle", dbReadOnly)
record.MoveFirs t

' ******** Problem-Kandidat: *********
record.MoveLast
' *************** *************** **********

record.Close
Set record = Nothing
Set base = Nothing
End Sub
*************** *************** *************** *************** *************** *************** **

Dec 16 '05 #1
1 3038
I have no idea what you said up there in German or Dutch, but from the
subject line I surmise that you may be running out of memory. You might
want to check how much RAM is available on your machine. If the table
you're opening has a lot of data in it, it's going to take more memory
to open.

Dec 16 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
6821
by: KWINTERS | last post by:
I have a 2GB Ram, Win2K SP4, SQL 2K SP3, 2 1.8GHz AMD processor server that is getting occasional "not enough storage space to complete this operation" errors on certain ASP pages. The only way to fix it is to do an "iisreset /restart" from a command prompt. I have the latest MDAC, Scripting engine and have checked all sorts of things. I cannot find any "on error resume next" problems in the code as suggested by Microsoft. this This...
289
1805
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 stay with C and still be able to produce Java byte code for platform independent apps. Also, old programs (with some tweaking) could be re-compiled and ported to the JVM. We have been developing such a tool over the last 2 years and currently...
0
2495
by: Jas Shultz | last post by:
I'm using Win2K3 Enterprise edition with the latest .NET framework installed. I have this problem with getting "out of disk space" errors. It doesn't happen all the time but it does happen. When I installed Sharepoint Services I got the error and had to reboot and then everything was fine. I get it sometime when running aspx pages. It's very odd. Usually, I can just remove the application and readd it from the properties menu in the IIS...
3
1943
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 following error, then load again: Not enough storage is available to complete this operation" I have 54Gigs of free space and a gig of ram. Rebooting has not helped. This is the GUI portion of a web project that is spilt into a DAL, BLL and
1
5681
by: Phil W | last post by:
I have a server which hosts a fair amount of websites, and over the last couple of weeks I have been getting the error "Not enough space on temporary disk" on ASP.Net pages. The error doesn't always appear, but when it does it seems to be there for good until I restart the web services. I'm using OleDb and Access databases. The odd thing about all this is that the error appears on ASP.Net pages, but not on old ASP pages - despite the...
2
16076
by: Jas Shultz | last post by:
I'm using Win2K3 Enterprise edition with the latest .NET framework installed. I have this problem with getting "out of disk space" errors. I have 35 Gigs of disk space free. It doesn't happen all the time but it does happen. When I installed Sharepoint Services I got the error and had to reboot and then everything was fine. I get it sometime when running aspx pages. It's very odd. Usually, I can just remove the application and readd it...
1
2018
by: pippyn | last post by:
I'm programming for a CE device with reduced key board, no mouse, and no touch screen. As such, I have to tab from button to button to get the focus on the button i want. Then to invoke the button with focus i have to hit two keys on the key board to send a space in order to "click" the button. I want to just hit one key, the enter key, instead. So, how do i trap the enter and turn it into a space? I tried putting the following code in...
3
9562
by: PW | last post by:
Hi, One of our clients is getting that error when they are trying to save a record but I can not duplicate it here. The data is on another PC and is linked to two workstations. The code (listed below) is just saving interests selected from a multi-list list box. I've never seen that error message before. Any ideas? What does it
10
18502
JamieHowarth0
by: JamieHowarth0 | last post by:
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...
0
10595
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10343
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9171
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6862
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5530
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5673
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4308
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3831
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3001
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.