***NEW CUSTOMER OFFER***
Get 15 minutes of free Live Help!

Use VBA to get the maximum lengths of values in a MS Access table

If you’ve ever imported a text file or a Microsoft Excel worksheet into Microsoft Access, you have seen how Access defaults the text field lengths to 255 characters.  This VBA function will display the maximum length of the values currently in each field of a

read more

posted on: Nov 27, 2009 | author: Carl Connett

Remove replication from a MS Access database

This VBA function copies or imports all the objects and database startup properties from a Microsoft Access replicated database into an un-replicated database.  It removes tablename_Conflict tables and removes replication-related fields like s_GUID, etc.

Background:

The Microsoft support site describes some methods that can be

read more

posted on: Aug 4, 2009 | author: Carl Connett

Get the name and description of all MS Access database objects

This VBA procedure shows you how to create a simple list of the objects in a Microsoft Access database.  The list it creates includes the object type, object name, and object description, which can be parsed using the Excel file in the download.

Descriptions can

read more

posted on: Apr 24, 2009 | author: Carl Connett

Find where an object or code is used in a Microsoft Access database

There are very sophisticated search programs to help you find occurrences of an object name or a piece of code within a MS Access database.  I usually find that this VBA code is sufficient to do the job.  It looks in tables, queries, code modules,

read more

posted on: Mar 10, 2009 | author: Carl Connett

Live Chat Software