Re: Compile, Crash, Scream

From: RobFMS (Rob_at__xIgnoreThisx_fmsinc.com)
Date: 04/23/04 

Date: Thu, 22 Apr 2004 22:16:29 -0400

I realized this may be a bit sideways, but remove the embedded excel
spreadshets, DataTime picker and progress bar controls from your application
for a short period of time and see how your application works. In other
words, create a new .mdb and import all the objects except those that
contain the controls mentioned.

Report back on how the application holds up.

HTH 

-- 
Rob
FMS Professional Solutions Group
http://www.fmsinc.com/consulting
Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
"PaulJS" <anonymous@discussions.microsoft.com> wrote in message
news:C5E984F7-B671-4CCD-ADD4-359E368B18DC@microsoft.com...
> Hi,
> I'm have a serious issue with a database I'm developing for a customer who
is anxious for it to be completed.  The problem...well, the symptom of the
problem, is very clear.  When I run the compiler in the VBA window, the
compiler progress bar gets about 3/4 through compiling, then Access
completely crashes.  I've had the problem on 2 different machines (on the
same MDB file under development).
>
> I'm really stuck.  I don't have a clue.  I'm not sure if exporting all
objects from the MDB file into a new, blank database might help.  I've been
building Access and SQL Server databases for years, but this is a real nasty
problem.  I thought it might just be the machine until I tried it on another
and had the same problem.  I can't open a support incident with Microsoft
because it costs too much money (WAY too much).
>
> Here's the specifics: I'm running Access XP, SP3.  The machines I've
experienced the crashes on are Windows XP Pro and Windows 2000 Pro.  I'm not
using any 3rd party objects or libraries in the project.  The database is
split into front and back end.  About the most "extravagant" objects in the
design are a couple of forms that have Excel spreadsheets embedded in them.
I'm using other Microsoft objects like Date Time Picker controls and
Progress Bars.
>
> If anyone has any suggestions (besides going into another line of work),
I'd be grateful.
>
> Thanks!
> PaulJS