Granite Consulting Table of Contents

The following is a hierarchical listing of all the pages in this web that can be reached by following the links.

Granite Consulting

• Microsoft Access Databases Available from Granite Consulting
• VolStar

  Look who's using VolStar

  What VolStar does

  Sample Forms

  Volstar Sample Volunteer Form

  Volunteer Software Lists of Lists

• Dispatch System

  dispatch/dispatch.zip

  dispatch/dispatch2000.zip

• Oilpatch Invoicing
• Rig Anchor System
• Business Directory Software
• Services of Granite Consulting
• Testimonials from Satisfied Clients
• Tony's Main Microsoft Access Page

  I've got an Access Question/Problem

  Tony's Microsoft Access Tips

  Microsoft Access Accounting Systems

  Advantages of Microsoft Access Based Accounting Systems

  Microsoft Access Email FAQ

  Sample Code illustrating looping through a DAO recordset

  Creating a formatted document in an email from Microsoft Access

  Sample code for sending a formatted email in Microsoft Access

  Email  reports as attachments from Microsoft Access

  Emailing a different report to each recipient

  Inserting data from incoming emails into tables

  Microsoft Access Email FAQ - Winsock

  Microsoft Access Email FAQ - Third Party Controls

  Sample Code illustrating use of the Mabry SMTP Control and Looping through a DAO recordset.

  IDSMail component sample code

  Microsoft Access Email FAQ - SendObject

  Microsoft Access Email FAQ - MAPI c

  Microsoft Access Email FAQ - Outlook

  Microsoft Access Email FAQ - Outlook

  Using an IIS Server

  Microsoft Access Email FAQ - DOS Mailers

  Microsoft Access Email FAQ - Lotus Notes

  Sending an Email via Lotus Notes

  Edit Lotus Notes emails before they are sent.

  Microsoft Access Email FAQ - Novell GroupWise

  Corrupt Microsoft Access MDBs FAQ

  After successful repair import into new Microsoft Access MDB

  Some Microsoft Access MDB Corruption Symptoms

  Operation failed

  To retrieve your data from a Corrupt Microsoft Access MDB

  Needs to be repaired" message then "Not a valid password"

  images/Access2007corruption.jpg

  Determining the workstation which caused the Microsoft Access MDB corruption

  Corrupt Microsoft Access MDB Causes

  Corrupt Microsoft Access MDB Causes - Oplocks

  Corrupt Microsoft Access MDB Causes - Hardware

  Corrupt Microsoft Access MDB Causes - Software

  Corrupt Microsoft Access MDB Causes - Samba

  To retrieve your data from a Corrupt Microsoft Access MDB

  To retrieve your data from a Corrupt Microsoft Access MDB

  Corrupt MDBs - MS Stuff

  Corrupt Microsoft Access MDB Causes - Novell

  Delete Records or Deleted Tables from Microsoft Access MDB

  Best Practices for Microsoft Access

  Table and Field naming conventions

  Tony's Object Naming Conventions

  images/TonysObjectNamingDatabaseContainerWindow.jpg

  images/TonysObjectNamingDatabaseContainerWindow2.jpg

  images/TonysObjectNamingAddTablesToQueries.jpg

  Microsoft Access Performance FAQ

  Microsoft Access Performance FAQ

  Microsoft Access Performance - Forms

  Performance in Microsoft Access is worse after splitting - My personal experience

  Ultra Frequent Application Deployment

  Microsoft Access (Office) Developer Edition FAQ

  Microsoft Office Access 2007 Developer Edition FAQ

  Microsoft Access 2000 Developer Edition FAQ

  Microsoft Access (Office) Developer Edition FAQ

  Microsoft Access Help System Tips

  WinHelp API

  Copy Protection or 'How to freely distribute demo databases'

  Faxing from Microsoft Access to Winfax Pro

  Microsoft Access Add-in (Library Database) Tips, Hints and Gotchas

  Microsoft Access Report Printing Criteria Selection Form

  Microsoft Access and the Year 2000

  Create Families from Volunteers User Interface

  MS Access ODE or MOD Runtime Installation Troubles

  Verify Appropriate Jet SP

  Why would I want to upgrade my Access app to SQL Server?

  My random thoughts on SQL Server Upsizing

  My random thoughts on SQL Server Upsizing

  My random thoughts on SQL Server Upsizing

  My random thoughts on Microsoft Access, Terminal Server and/or Citrix

  Auto FE Updater

  Late Binding in Microsoft Access

  Using bar codes within an application

  Microsoft Access & TCP/IP programming

  Bloating Front End (FE) Microsoft Access MDB/MDEs

  Image Handling

  Miscellaneous Access Tips

  One efficient way of using SQL queries in code

  Splitting your Microsoft Access MDB into a front end and back end

  Splitting your Microsoft Access MDB into a front end and back end - Why?

  Splitting your Microsoft Access MDB into a front end and back end - Overview

  Splitting your Microsoft Access MDB into a front end and back end - Details

  Create an MDB from an MDE

  Sending reminders

  Backup, do you trust the users or system administrators?

  How to effectively run multiple versions of Access on the system

  The TempTables.MDB illustrates how to use a temporary MDB in your app.

  Calendars and Microsoft Access

  Reading text (.txt) files from with Microsoft Access

  Updating an Access Backend MDBs structure using VBA code

  Access 97 to Access 2000/2002 conversion issues/problems/bugs

  Microsoft Access Object Usage Statistics

  Microsoft Access Reports and Dot Matrix Printers

  Timberline ADO Connection String

  How do you get rid of troublesome references?

  Progress Bars and Microsoft Access

  Why I don't like cascade updates and deletes in Microsoft Access

  Currentdb.RecordsAffected Property in Microsoft Access

  Positioning on a continuous form

  Locking fields on a form

  If an Access/Jet index is a duplicate of another index then Access/Jet does not take any extra space.  

  images/Relationships_JobTable.jpg

  Setting Startup Options Programmatically in Microsoft Access

  Tracking users entering and exit

  Shifting fields left on a continuous form

  Using data from the previous year in Microsoft Access

  Microsoft Access Compatible Compression DLLs, OCXs, etc

  Relinking tables in Microsoft Access

  Referencing a control on a subfo

  images/QueryExpressionBuilder.jpg

  Microsoft Access - Using NotInList in a combobox

  Decompile or how to reduce MDB/MDE size and increase startup performance

  Screen shots of error messages

  Reserved Error (-1517) in Microsoft Access

  Out of MS-DOS file handles - error 3042 Microsoft Access

  Unexpected Error (40230) in Microsoft Access

  Office XP MOD/Access 2002 runtime can't install on Windows 2003 Server

  Unexpected Error (32811) in Microsoft Access

  DSN Less Connections and wierd ODBC problems

  Microsoft Access

  "MSysAccessObjects" or "MSysAccessStorage" is already opened exclusively

  3211 - The database engine could

  Tony's Microsoft Access Downloads

  Setup Switcher

  OCX/DLL Version Checker

  Newsgroup Answers MDB

  Microsoft Access 2000 PDW Setup Modifications

  Multiple Microsoft Access Snapshot Files Printing Utility

  Microsoft Access- Ensuring uniform control width on forms and reports

  files/UniformControlWidthV1.00.zip

  Microsoft Access Service Packs, Release, Patches and Updates

  Microsoft Access Developers Edition Service Packs, Release, Patches and Updates

  Microsoft Access Developer Edition Versions

  Latest Microsoft Access Knowledge Base Articles

  Microsoft Access Links

  Microsoft Access third party utilities

  Microsoft Access miscellaneous third party utilities

  Microsoft Access Multilingual/Localization Solutions

  Convert Access to Visual Basic, Delphi, Java, ASP or ASP.NET

  Serial Port Communications

  Access Compatible Grid Controls

  Querying and Reporting

  Creating PDF files from within Microsoft Access

  Microsoft Access User Groups

  Tony's Main Microsoft Access Page

• Bugs I've found
• Granite Consulting Web Site Table of Contents
• Search granite.ab.ca
• Contact us
• Privacy Policy

[ Home ]

   Auto FE Updater - the convenient means to keeping your users Front End MDE/ACCDEs (and other files) current.

Granite Fleet Manager - the best designed fleet maintenance tracking and management system available