asked on

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: https://www.experts-exchange.com/questions/27322848/Access-vs-System-Memory.html?anchorAnswerId=36588470#a36588470

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rey Obrero (Capricorn1)

Shanan212

ASKER

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!

SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Shanan212

ASKER

Thanks all!