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.


The Microsoft support site describes some methods that can be

read more

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

Live Chat Software