vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

 

Home  Contact Us
Order our Software

RSS & Newsletter  
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

  Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

The Workbench  Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile,  shutdown database Read and Download

The Toolshed 
Searchable help file comprising of all the information at vb123.com plus hidden downloads etc. Read More



The Toolbox

Libraries of software that we regularly import into our projects. This is a newer version of the Toolshed More..


Access >>> SQL 
Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query
translation and web form conversion.
Read More

SharePoint
For our company file sharing and task management, we use
SharePointHosting

DryToast 
Backup and query your BaseCamp
® projects
Read More


Datamining/Graphs

Explore your data with this versatile graphing and data mining shareware tool.  Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

Like FMS Products?
Purchase them from us and get a free Workbench or Toolbox  More

About The Editor Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia
Contact Us ...

Search ...

or try our new site built with SharePoint Designer
 vb123.com.au
 

 

Next Tip    Improving The Performance Of Outlook

By Scott McManus

Compacting Outlook 2000 personal folder files.

You may be forgiven for thinking that when you archive your outlook folders that Outlook would also compact the personal folder file. (Usually a *.pst or *.ost file located in the Microsoft\outlook local application data folder for your login identity).

However Outlook does not release the space used by a deleted or archived item. Hence your PST file keeps growing month to month. I recently found that my file was 162 Meg so I decided to make a backup copy of the file and then archive it. I found the archive to be 76 Megs and expected a suitable reduction in the size of my PST file. Alas it remained the same size. I found the following ‘hard to find’ option.

By right clicking on the Outlook Today (Personal Folders) Item (figure 1) in the Folders View area and then selecting ‘Properties for "Personal Folders", I was presented with the following menu box. (Figure 2)

From there select ‘Advanced’ where you can find the option for compacting all of the folders that come under the Personal Folder. (Figure 3). After Compaction my PST file was reduced to only 83 Megs.

Other Outlook Tips From GR Include

Try running SCANPST.EXE once every month or two.  This program should remove any errors in your mailbox.pst file.

Do not forget to backup mailbox.pst or outlook.pst or *.pst to another computer or a tape or a cd as this can easiliy be imported into another version of Outlook after your computer crashes.

When transferring from one PC to another, it is possible to export all the email rules.  This can save you a lot of time.  You will of course want to import the mailbox.pst file into your new version of Outlook.

Click on this button Next Tip to head to the next page in this loop

This article was written by Scott McManus

 

Links >>>  Home | Search | Workbench | Orders | Newsletter | Access Security | Access professionals