vb123.com.au                                                          

  Welcome To The Access Unlimited Newsletter - Edition 33
See all newsletters

Access Unlimited is an email newsletter that provides free tips, help and information for skilled Microsoft Access users and related software disciplines.


Produced by Garry Robinson (known below as "Ed") from Sydney, Australia.

In this edition,

INCORPORATING OUTLOOK TASKS INTO ACCESS
SAVING SPACE IN OUTLOOK
CLEANUP YOUR ACCESS DATABASE
GET OUT OF DATABASE JAIL WITH EXCEL
SECURITY OF HARD DRIVES
SOAP BOX

--- INCORPORATING OUTLOOK TASKS INTO ACCESS

One of the most important parts of managing a software business is keeping track of all the different jobs, possible jobs, and any kind of job that passes your way. When you're not busy, your system for managing these requests can be kept on paper, in a database, in a Word file, and, more than likely, in your e-mail inbox or task box. When you're busy, trying to pull all of these things together at one time can be a hit-or-miss process. We now integrate our Outlook tasks into an Access database so that we can prepare reports and hook into other related project data. This exercise also included a voyage into using XML to export from Outlook and view that information inside Microsoft Access.

Garry Robinson and Scott McManus write about this in the latest edition of Smart Access and it is free to read at the following address if you get
there before the end of July.   If not then why not purchase the magazine.

http://www.pinpub.com/


--- SAVING SPACE IN OUTLOOK

Did you know that you can right click on an attachment in Outlook and choose Remove to remove the attachment.  This can clear up lots of space once you have saved the attachment to your hard drive.  You will need to Open the email in its own window first before right clicking on the attachment icon.

--- CLEANUP YOUR ACCESS DATABASE

One of the hardest things to do with an Access database is cleaning up all the objects that are no longer required in a database.  This article outlines how the crew at GR-FX goes about this task.

http://www.vb123.com/Toolbox/02_access/dbcleanup.htm



--- GET OUT OF DATABASE JAIL WITH EXCEL

An Access 2002 database that I was writing some really crazy recordset manipulation code ran out of virtual memory and became totally and utterly
corrupted.    That is I could not open it, repair it, compact it or even fix
it with Microsofts compact and repair utility of last resort described at

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q295334


But I could read the data into Excel using the Data ... Import  menu option. At least this allowed me to retrieve a weeks worth of data.

More related information on corruption at Microsoft


--- SECURITY OF HARD DRIVES

Do you share a disk drive with others in a local environment?  Well make sure that you do not share the root directory as modern viruses are using the c: & d: drives as starting points for their malicious tasks.   So turn off the root drive share and set-up a new directory such as c:\MyData, move your files below that directory and share that instead.  This only applies to people who access the internet.  That is EVERBODY....

--- SOAP BOX

Pentium 4 and AMD Athalon fans make too much noise.  If you have a quiet office, be careful and purchase a new age computer with a not so noisy fan.

Access Macros may seem easy to set up in the first place but they become difficult to maintain/debug in the long run.  Use the Access to VBA converter and phase them out of your system and start learning Visual Basic. This comes from much experience in taking over databases designed with Access macros.

There, that has been said.  ED

--- GOOD READING

Access Report captions and no data tips from FMS. http://www.fmsinc.com/tpapers/genaccess/reporttips.html

Informix SE documentation  (c-isam version).  Includes the great SQL syntax manuals. http://www.cs.umb.edu/~informix/answers/answers/english/se72win.htm

ZdNet has a couple of reviews if you are getting 30+ emails a day. Personally I prefer to review email online using web mail and kill the junk before it gets to the e-mail box.  ED

http://www.zdnet.com/products/stories/reviews/0,4161,2870419,00.html


WRAPPING THIS EDITION UP

We have moved vb123.com to the USA.  Why bother you might say!  Well we are
now having 1000 different visitors a day and 750 are coming from USA.   Also
Aussie internet traffic prices are not competitive for a busy web site.

http://www.vb123.com/

Thanks for reading this edition and let me know if vb123.com is faster or slower...


Garry Robinson


-- OUR SOFTWARE AND RESOURCES -----------------------

Read the books that we read
---> http://www.vb123.com/books/


Explore your data visually using our popular Access
data mining shareware
---> http://www.vb123.com/explore


View our web site as a searchable eBook and have access to all the downloads discussed in the articles and information pages at the popular vb123.com web site.
---> http://www.vb123.com/Toolbox/


So thanks for reading our popular newsletter.
Feel free to make comments, copy the email to a friend
or maybe even contribute to the next edition.


Garry Robinson - Software Consultant


Click on this button to read the previous edition of Access Unlimited 

Published  2002-06