Clearing the clipboard/memory 
Author Message
 Clearing the clipboard/memory

 Help me, I am banging my head against the wall.  I am running into a
tinsy little problem.  Due to certain processes that my database goes
through, the size of the database grows Immensely due to the
'clipboard' of deleted items.  I know that I can compact that database
to get rid of the excess junk, but is there anyway to just empty the
clipboard, or remove the 'temporary items' from the system from code,
that wouldn't disrupt the database operation to badly?

--
He who learns but does not think is lost, he who thinks but does not lea

Sent via Deja.com http://www.*-*-*.com/
Share what you know. Learn what you don't.



Fri, 01 Feb 2002 03:00:00 GMT  
 Clearing the clipboard/memory

Quote:

>  Help me, I am banging my head against the wall.  I am running into a
> tinsy little problem.  Due to certain processes that my database goes
> through, the size of the database grows Immensely due to the
> 'clipboard' of deleted items.  I know that I can compact that database
> to get rid of the excess junk, but is there anyway to just empty the
> clipboard, or remove the 'temporary items' from the system from code,
> that wouldn't disrupt the database operation to badly?

Is this design stuff?  Or just mass amounts of stuff you put through
tables?  If it's just table data you want to be able to drop at any time,
have you considered using an external DB that you could just delete at will
and create from scratch?

--
HTH
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
|  gHaD (Aaron Robinson)  | The Never-Ending Commute  |
|  MJM-PC Solutions, Inc. | Web & Database Developer  |
|       Chicago, IL       |   Will work for Dew?!     |
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| If you lie to the compiler, it will get its revenge.|
|      - Henry Spencer                                |
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-



Sat, 02 Feb 2002 03:00:00 GMT  
 Clearing the clipboard/memory
Actually it was a design problem that I had programmed into my Users
Online Process.  Due to certain limitations, and restrictions, and
because I thought it was cool, I was creating forms off of a master
form, and then deleting them when I didn't need them.  That was
creating and deleting so many forms that I actually was told that the
system Memory was full (Which on this computer is odd!!!)  I figured
out how to do relatively the same thing, and get even better results
without having to create and delete forms!  Thanks for the help though!

Drew


Quote:

> >  Help me, I am banging my head against the wall.  I am running into
a
> > tinsy little problem.  Due to certain processes that my database
goes
> > through, the size of the database grows Immensely due to the
> > 'clipboard' of deleted items.  I know that I can compact that
database
> > to get rid of the excess junk, but is there anyway to just empty the
> > clipboard, or remove the 'temporary items' from the system from
code,
> > that wouldn't disrupt the database operation to badly?

> Is this design stuff?  Or just mass amounts of stuff you put through
> tables?  If it's just table data you want to be able to drop at any
time,
> have you considered using an external DB that you could just delete
at will
> and create from scratch?

> --
> HTH
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> |  gHaD (Aaron Robinson)  | The Never-Ending Commute  |
> |  MJM-PC Solutions, Inc. | Web & Database Developer  |
> |       Chicago, IL       |   Will work for Dew?!     |
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> | If you lie to the compiler, it will get its revenge.|
> |      - Henry Spencer                                |
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

--
He who learns but does not think is lost, he who thinks but does not lea

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.



Sat, 02 Feb 2002 03:00:00 GMT  
 Clearing the clipboard/memory
Use the EmptyClipboard api.  (You can probably find this on Dev's website).
I've got module that does it, but I've got a gillion other things in there,
and it would be confusing if i posted it.


Sat, 02 Feb 2002 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Access XP: Clearing the clipboard / not saving data to the clipboard

2. Clear the clipboard

3. Clipboard.clear

4. Clearing the clipboard from Access

5. Clear Clipboard

6. Clipboard.Clear - Returns Error 424 - Object Required

7. clear clipboard

8. Clearing the Clipboard

9. Clear Clipboard on file.close

10. Clearing the Clipboard Contents

11. clear clipboard

12. Macro to clear clipboard

 

 
Powered by phpBB® Forum Software