Access file gets bigger after changes
-
I opened an MS Access file and made some changes on it (just remove codes). But the file is getting bigger (double size). Are there any way to keep the file smaller? Lan hue sau ai lan hue heo Lan hue sau doi trong heo ngoai tuoi
Hi, Try compacting and repairing your database. Also, if you don't need to access the source of your database in the field, making your databases .MDE or .ADE files (they completely compile the VBA and remove the source code, significantly reducing the size). They also prevent changes being made to the database. When you opened the file, did it do a file format conversion? IE, was it an Access 97 database opened in 2003 for example? Regards, -Adam.
-
Hi, Try compacting and repairing your database. Also, if you don't need to access the source of your database in the field, making your databases .MDE or .ADE files (they completely compile the VBA and remove the source code, significantly reducing the size). They also prevent changes being made to the database. When you opened the file, did it do a file format conversion? IE, was it an Access 97 database opened in 2003 for example? Regards, -Adam.