Erwin Craps - IT Helps
Erwin.Craps at ithelps.be
Sat Feb 14 16:56:48 CST 2004
Gustav... Is'nt that a bad idea? The size of a database get bigger (but not only reason) due to compilations. Code get compiled when it gets used, but also queries. So if you would make the file readonly you coder and queries never get compiled and your app is slower. Erwin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Saturday, February 14, 2004 2:15 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] increasing database size Hi Pedro If your frontend is not supposed to write data to itself, you may write protect the file when you have finished design changes and compacting. /gustav > how is it possible that a database increases its size by 1/3 when opening a complex form? > Opening this form in formview or designview also costs (pentium4 2600Mhz 256MB-ram) about 25 sec. > How is this possible and can i decrease the time? _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com