Anyway to clear access memory

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
LVL 13
Shanan212Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
<Is there any other way to clear data/delete data from db without doing compact & repair?>

sorry but NO, afaik
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
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
 
Rey Obrero (Capricorn1)Commented:
?
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Shanan212Author Commented:
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
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
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
 
Shanan212Author Commented:
Thanks all!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.