[AccessD] Form Corruption, Part II

Thanks Doug, but I am ok for crashing.  Andy sent me a ton of stuff (only
kidding)

Thanks for the thought - appreciated.

Max



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: 12 May 2009 16:02
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Form Corruption, Part II

I don't know if this will be any help for you, but I once had a form which
started crashing the db every time it was opened.  I did a decompile and
rebuilt the database by starting from scratch and re-importing everything,
to no avail.  It eventually discovered that I had modified the form's
underlying recordsource sql, and it was this that was causing the problem.
When I built a standalone query to test, it was immediately obvious that it
wasn't working.  Once I fixed the recordsource, the form started working
again.

Doug Steele
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com