freeaccess.cjb.net 
 

FreeAccess Newsletter No 6 - March 2002

  Free Access Tools and Databases AAD CONSULTING Sydney Australia_ | _Advanced Access Development
     
What's New at FreeAccess?

Smart Form Wizard 5.0
Now with Find First and Find Next buttons. Build ready to run Access forms with navigation and autofiltering.

Meeting Tracker Database
New Create Tasks, allocate responsibility to a Task Owner, assign people to Task Teams, record meetings and attendance. An instant Meeting Summary Report can be printed, emailed or exported to Word or Excel.

Access 2002/XP
XP versions of all FreeAccess addins and databases are now available.

From our sponsor ecampus.com:
Access 2002 : The Complete Reference (w/CD) - Only US$29.99 Save US$10

 Phantom Microsoft Files - for subscribers only

Hard to find files that are no longer on the Microsoft web site - new files in each newsletter

Access97 WizardBuilder Wizard
Build Your own Access Wizard

The extraction password for the zip file was included in the subscriber mailing of 11 March 2002.

 Downloads

Office Downloads
Office XP Tips & Tricks Center

 Code sample

Recover a corrupt database

If you are encountering database corruption, you can perform the following steps:

1. Export all form objects in the database to text files using the following procedure:

Application.SaveAsText(acForm, "<Form>", "<Path and File Name>")

where <Form> is the name of an existing form object, and <Path and File
Name> is the path to and the file name of the text file to be created.

2. Create a new database.

3. Import all the database objects (except form objects) into the new
database:

a. With the new database open, point to Get External Data on the File menu, and then click Import.

b. In the Import dialog box, locate and then click the damaged database, and then click Import.

c. On the Tables tab in the Import Objects dialog box, click Select All. Repeat this step for each type of object except the form object.

d. Click OK to import the selected objects.

4. Import each of the exported text files to the new database by using the following procedure:

Application.LoadFromText(acForm, "<Form>", "<Path and File Name>")

where <Form> is the name of the form object, and <Path and File Name> is the path to and the file name of the text file to be imported.

For more info about database corruption, refer to this MSDN article:

Q209137 ACC2000: How to Troubleshoot/Repair a Damaged Jet 4.0 Database
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q209137

 Useful links
Office Community
 Coming soon...

A new Access HRIS database application
A comprehensive leave and training tracker

A new version of the Project Management database
Incorporating daily time management

New versions of:
Ezy Filter
Ezy Reporter
Vizual Einstein

Also on the drawingboard:
Instant Invoicer Wizard
Consolidation Query Wizard
Call Logging Database
Currency Exposure Manager Database

_Back Issues

 

No 1 September 2001
No 2
October 2001
No 3
November 2001
No 4
Dec/Jan2002
No 5
Feb2002

Extraction passwords for Phantom Microsoft Files for these issues were included in the subscriber mailing of 11 March 2002.

 

Top

Top

 
CONTENTS:
What's New
Phantom Microsoft files
Downloads
Code sample
Useful links
Coming soon...
Back Issues

Subscription to this newsletter is free.

This newsletter may contain links to sites on the Internet which are owned and operated by third parties. AAD CONSULTING is not responsible for the content of any such third-party site.

Any files are provided "as is", without warranty of any kind. AAD CONSULTING does not assume any liability for use or the consequences of use.

To unsubscribe from this mailing list, enter your email address:

Have questions or comments?
Send them to us.

Access is a trademark of Microsoft Corporation.

©2001-2002
Anthony D'Ambra.
All rights reserved.

Top