Darryl Collins
Darryl.Collins at coles.com.au
Sun May 3 19:32:00 CDT 2009
I have found version 3.0 here http://www.peoplelinks.co.uk/msaccess/msaccess.html regards Darryl -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman Sent: Sunday, 3 May 2009 4:59 AM To: Access Developers discussion and problem solving Cc: max Subject: Re: [AccessD] Form corruption Janet 1) Steve is soooooooooooooooooooooo going to hear that "out-house consultant" line :) 2) Max has a beautiful little Access app called "EatBloat" which I believe is in version 4.1 at the moment ...it takes everything in your mdb and exports it to text files and then builds a new mdb using the exported text files from the old one: a) ime I've never had a fe corruption issue that "EatBloat" couldn't fix b) better yet, as its name implies, it eats all that bloat in your mdb 3) I can e you my copy but better yet would be for Max to send you his latest ...he did have a dl point at one time but I'm too old to recall it and too short-tempered these days to look for it :) William -------------------------------------------------- From: "Janet Erbach" <jerbach at gmail.com> Sent: Friday, May 01, 2009 3:18 PM To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Subject: [AccessD] Form corruption > Hello all - > > We manage our order processing/shipping/product inventory using an access > database application developed by some guys in Pennsylvania. I have > created > a dozen custom functions within this app that have allowed me to do things > that the original app didn't include. But form corruption sneaks up on me > far more frequently than seems normal. > > It seems to happen most when I've copied a form that I already created > and > use that as the starting point for a new form. I'll notice that my > response > time starts to seriously degrade - I click on an object and it's seconds > before I can move it or edit it. I'll save the form and my screen will go > blank while it saves, which takes longer than normal. When that starts to > happen I'll compact and repair my database and re-compile all my code just > to clean things up...but it doesn't seem to help. Finally it gets to the > point where I'll try to open the form in design mode and get one of two > behaviors: 1) a message box saying there aren't enough system resources > to > complete the operation or 2) NOTHING HAPPENS - the form won't run, won't > open - nothing. > > Is there something I can do to salvage these corrupt items? Should I not > be > using a copy of a form as the basis for a new one? Could it be related to > bloat? I'm making these changes in the front end database on my PC...The > front end on the other pcs here are usually around 55 MB, but on mine it > bloats up to around 290 - and even after compact/repair it only shrinks > to > about 170. Granted, I have a few objects, forms, and tables that are not > installed on the other front ends - but it seems like my front end > shouldn't > be THAT much heftier! > > Any suggestions? > > > Janet Erbach > IT Administrator > Natural Healthy Concepts > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material.