Home ] Order ] Sales and Support ] Data Reviewer ] Access Links ] [ Access Tips ]

 
  • Access all versions Tip: Linking tables in a shared environment.  When linking tables in a network or shared environment, use the full path or instead of using a mapped drive name.  This way other users will not have to worry about mapping their drives precisely the same as yours.  Example - instead of linking a file as L:\Access\Inventory.mdb link as \\NetData\Access\Inventory.mdb.

 

  • Access 97 tip: Microsoft has an improved repair and compact utility.  This utility is part of the updated Microsoft Jet database engine version 3.51 provides an improved Compact utility that combines Compact and Repair into a single process.  The download includes a stand-alone utility that allows you to compact databases created with Microsoft Jet database engine 3.x, this stand alone utility may be able to repair databases that are not repairable from within Access. For details see the knowledge base Article ID: Q172733.