UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Compact With Hot Key, Access 2007    
 
   
jysharp2003@yaho...
post May 22 2019, 06:48 AM
Post#1



Posts: 39
Joined: 23-January 19



Hi all.
In the OLE Access days compacting was done with a key depressed maybe CTRL plus Compact.
Can someone speak on what key this was and if applicable in 2007 or greater? My application seems to be bloated and think this method would clean all records. I was taught this hot key method forced all the white table space out and truly compacted the application.
Thanks for the time and reply.
Go to the top of the page
 
GroverParkGeorge
post May 22 2019, 07:15 AM
Post#2


UA Admin
Posts: 35,867
Joined: 20-June 02
From: Newcastle, WA


I am not sure I have ever heard of such a technique. "...compacting was done with a key depressed maybe CTRL plus Compact."

Perhaps a simple Compact & Repair is appropriate, though, in any case.

What happens is that deleting objects and records in an active accdb doesn't actually remove them physically. They are marked "deleted", but remain as artifacts in the accdb. When you do a Compact & Repair, the Compact part of that process does physically remove objects and records flagged as "deleted".

I'd love to hear more about this "hotkey" method, if it exists.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
DanielPineault
post May 22 2019, 07:56 AM
Post#3


UtterAccess VIP
Posts: 6,899
Joined: 30-June 11



I've never heard of such, but that doesn't mean it doesn't exist.

That said, perhaps someone had created a proc to perform the compact and use an AutoKeys macro to initiate it through a key combination? Just a though. Personally, I just added the Compact button to my QAT and it is a click away whenever I need it.

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
GroverParkGeorge
post May 22 2019, 08:07 AM
Post#4


UA Admin
Posts: 35,867
Joined: 20-June 02
From: Newcastle, WA


Yes, what Daniel said. It may have been a function or macro invoked with a hot key. That makes sense in the context.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
jysharp2003@yaho...
post May 22 2019, 10:17 AM
Post#5



Posts: 39
Joined: 23-January 19



It was MS function. I will use the compact and repair as you all stated.
Thanks to all.
Go to the top of the page
 
GroverParkGeorge
post May 22 2019, 10:28 AM
Post#6


UA Admin
Posts: 35,867
Joined: 20-June 02
From: Newcastle, WA


Well, I'd be really interested if you can ever find it again. It's always good to learn.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    16th October 2019 - 03:09 PM