Solved

Anyway to clear access memory

Posted on 2011-09-23
6
238 Views
Last Modified: 2012-06-27
Hi,

In my access, I am deleting few large tables/recreating. I was told that when you delete a table, the data is actually marked for deletion and it never leaves the db unless you do 'compact & repair"

Is there any other way to clear data/delete data from db without doing compact & repair?

Just a final try!

Thanks!

This is my other thread: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27322848.html#a36588470
0
Comment
Question by:Shanan212
6 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 167 total points
ID: 36588542
<Is there any other way to clear data/delete data from db without doing compact & repair?>

sorry but NO, afaik
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 166 total points
ID: 36588619
Shanan212

Set your db to do a Compact On Close (see image),  Then, as you were going in the other Q ... run your delete / clear querie(s) ... then close the DB ... and it will Compact.

mx
Capture1.gif
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 36588637
?
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 13

Author Comment

by:Shanan212
ID: 36588649
Thanks!

I know I am hitting the head on brick wall now :p

But something like this?

http://www.tek-tips.com/viewthread.cfm?qid=238809&page=1269

- I have alot of temp tables...which I regret now. Although not a major thing (that db crashing somewhere in middle), I tried compacting via vba each time a loop is called but didn't work (make sense since compacting requires db to be closed)

Let me know!
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 167 total points
ID: 36588773
Shanan212,

<No Points wanted>

The link you posted is only relevant if you are using recordsets in your loops...
Then you must close them all and set them to nothing:
rst.Close
set rst=Nothing
...For lack of a simpler explanation, this reclaims "Windows" (OS) memory.

What you are referring to in here, in Access is not "technically" Memory, but rather resources/space inside the database internal file structure.

As the previous experts have posted, this can only be reclaimed/cleared by using C&R.
0
 
LVL 13

Author Closing Comment

by:Shanan212
ID: 36589211
Thanks all!
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

816 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now