Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Database size
Access databases get bloated when they are modified. You need to compact it, and it will shrink dramatically. Open the database in Access, from the menu select Tools/Database Utilities/Compact and Repair Database, and all should be well. Mike- PCCP
- Post #2
- Forum: Microsoft: Access Other topics
-
Replication and Synchronizing
In Visual Basic, you do it like so: dbMaster.Synchronize ReplicaDBName, dbRepImportChanges where dbMaster is the master database, ReplicaDBName is the full path name of the replica, and dbRepImportChanges is a predefined constant telling the Master to import changes from the Replica but not to...- PCCP
- Post #2
- Forum: Microsoft: Access Other topics
