Shanan212
asked on
Access vs System Memory
Hi there,
I am running a database which outputs 'many' records that it crashes the db at a point when the output table (when saved) size reaches 1.99gb.
What I mean my 'when saved' is that; after crashing/showing error msg, I save the db and the db size is 1.99gb. This is ok since thats the maximum an access db can take.
Now what I did is, cleared the output table, and tried to run the query again and the same msg (error msg) popped up.
When I cleared the output table and saved the db, its still 1.99gb. This is why the error still showing up.
Is there anyway to make the db go down in size without saving it under different name? (considering I already cleared the output data from the output table)
Thanks!
I am running a database which outputs 'many' records that it crashes the db at a point when the output table (when saved) size reaches 1.99gb.
What I mean my 'when saved' is that; after crashing/showing error msg, I save the db and the db size is 1.99gb. This is ok since thats the maximum an access db can take.
Now what I did is, cleared the output table, and tried to run the query again and the same msg (error msg) popped up.
When I cleared the output table and saved the db, its still 1.99gb. This is why the error still showing up.
Is there anyway to make the db go down in size without saving it under different name? (considering I already cleared the output data from the output table)
Thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I see!
That answers many questions!
Is there any way to compact and repair using vba? such that I can run it via a button?
Thanks!
That answers many questions!
Is there any way to compact and repair using vba? such that I can run it via a button?
Thanks!
Note that you cannot do a C&R on a db that is in use, ie ... someone has the db open, and you try to do a C&R externally. But yes, it can be done via vba.
mx
mx
Another question, is your database split by any change?
I guess not, that might also helps you maintaining your database in a propper way.
You Data will be stored at your Backend and the Forms, Reports , Querys in FrontEnd.
Lots of advantages of doing this, see for more info this thread by HightechCoach:
http://www.hitechcoach.com/index.php?option=com_content&view=article&id=35:split-your-access-database-into-application-anddata&catid=65:split-database
Hope this helps,
I guess not, that might also helps you maintaining your database in a propper way.
You Data will be stored at your Backend and the Forms, Reports , Querys in FrontEnd.
Lots of advantages of doing this, see for more info this thread by HightechCoach:
http://www.hitechcoach.com/index.php?option=com_content&view=article&id=35:split-your-access-database-into-application-anddata&catid=65:split-database
Hope this helps,
>>Approaching the 2GB limit is like approaching a Black Hole (seriously).
Does that make it more like the Schwarzchild Radius, or the Chandrasekhar Limit?
:)
(All silliness aside, it is a most dangerous limit to approach.)
Does that make it more like the Schwarzchild Radius, or the Chandrasekhar Limit?
:)
(All silliness aside, it is a most dangerous limit to approach.)
Better yet:
http://www.reuters.com/article/2011/09/22/us-science-light-idUSTRE78L4FH20110922
I predicted this 30 years ago. Einstein's theory never made sense to me. Imagine the ramifications of this if it holds up!!!
mx
http://www.reuters.com/article/2011/09/22/us-science-light-idUSTRE78L4FH20110922
I predicted this 30 years ago. Einstein's theory never made sense to me. Imagine the ramifications of this if it holds up!!!
mx
MX,
Until another lab replicates the result, I refuse to believe it. This has been one of the most thoroughly tested theories in the history of physics :)
Patrick
Until another lab replicates the result, I refuse to believe it. This has been one of the most thoroughly tested theories in the history of physics :)
Patrick
Look at the number of peeps involved at that lab ....
If that doesn't pan out, then we are doomed.
mx
If that doesn't pan out, then we are doomed.
mx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My coding above goes around access to compact data via button click.
DoCmd.Close acForm, Me.Name, acSaveNo
Above coding is recommended to close the current form
DoCmd.Close acForm, Me.Name, acSaveNo
Above coding is recommended to close the current form
"Since you cannot compact and repair via VBA command, "
Well, you can, but not from the db you are in, You need to do it from another db.
"I added this to initiate compact and data."
\What did you add?
mx
Well, you can, but not from the db you are in, You need to do it from another db.
"I added this to initiate compact and data."
\What did you add?
mx
ASKER
This at the end point of my function!
SendKeys "%(FMC)", False
SendKeys "%(FMC)", False
ASKER
But this is a hassle since I cleared whatever that was output and it still shows 1.99gb.