By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,398 Members | 1,372 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,398 IT Pros & Developers. It's quick & easy.

recordset.MoveLast - "not enough space on temporary device"

P: n/a
Hallo,

Kurzversion: erstellt Access eine volle Kopie der Tabelle, wenn mit
Currentdb.OpenRecordset("Tabelle") 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.CurrentDb
Set record = base.OpenRecordset("Tabelle", dbReadOnly)
record.MoveFirst

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

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

Dec 16 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.