Solved

Anyway to clear access memory

Posted on 2011-09-23
6
235 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 119

Accepted Solution

by:
Rey Obrero earned 167 total points
Comment Utility
<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
Comment Utility
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 119

Expert Comment

by:Rey Obrero
Comment Utility
?
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 13

Author Comment

by:Shanan212
Comment Utility
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
Comment Utility
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
Comment Utility
Thanks all!
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

762 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

8 Experts available now in Live!

Get 1:1 Help Now