473,326 Members | 2,182 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Access 2003 MDB Startup Form Causes Crash

I'm using Windows 8, but had the same problem occur in XP with Access 2003. MDB is located on a 2008 Server with HyperV.

For the past month I have been struggling to resolve this issue or even find the cause of it and just can't figure it out.

I have a 400mb MDB that contains mostly all linked tables to another MDB and SQL server and a boat-load of forms & reports.

I've been regularly modifying VBA code and it seems that after a good deal of code changes in various modules, I'll exit the application and attempt to reopen it and I get either "access has stopped working" error or "There was a problem sending the command to the program." or one of those errors. However, IF I hold the shift key down, and launch it, it starts normally.

One would think "Look at your startup form", which I haven't touched, but ok, after bypassing startup by holding shift key, DB launches and appears normal, (except doesn't launch into my startup form). Then I manually launch the startup form, and all works normally???

I remove the form from the startup process, launch the MDB without holding the shift key and it works fine. (no startup form, DB window appears only)

Again, after a normal boot (with no startup form), I can call the startup form, and it runs!?

ADDITIONALLY, because I have been having this happen daily, I've been getting used to making copies, but I'm finding that 50% of the time, the copied MDB experiences the same problem? I can copy a good working version, and the copy will produce the same problem?

Has anyone see anything as crazy as this? Any ideas?
Nov 27 '12 #1
4 3209
zmbd
5,501 Expert Mod 4TB
Without the code it is a hard thing to help you with...

What I would suggest to you at this stage is:

Bypass the startup as you already have.
Open the code behind your startup form.
On the very first line follwing the sub ... () place the STOP
SAVE
Debug - Compile
Fix any errors the show-up. Compile after each fix. Note that you must comple after each fix as the debugger stops at the first error encountered.
SAVE
Close and reopen the database.
You should enter the debug state immediately.
[F8] thru your startup

Once: Pressing [F8] fairly fast.
Second time: fairly slow.

If you get thru this two times without fault, or if when you [F8] slowly thru the code all is well, then more than likely the code is calling something that is not initalized and the application level error handling isn't running yet either.

This is a hard one to trouble shoot even with the code.

Please post the code - remember to format it using the <CODE/> button in the toolbar.
Nov 27 '12 #2
NeoPa
32,556 Expert Mod 16PB
Please also check out these instructions before posting. One of them may help to find the error.

Before Posting (VBA or SQL) Code.
Nov 28 '12 #3
Yes, I know this is an ancient thread, but I came across it after experiencing a similar problem, and thought it was worth sharing my solution in case anyone else comes looking. I basically just copied all the code behind the startup form into Notepad, deleted the code from the form itself, and then copied back in the version from Notepad. It seems to have done the trick, though I can't explain why.
Aug 9 '18 #4
NeoPa
32,556 Expert Mod 16PB
Hi Calpurnia.

Responding positively to an old thread is no problem.

What you've done there is to cause Access to re-compile the code afresh. It has to junk any previously held compiled code for that form and that might have got corrupted or somehow out of step. So, repasting in all the code can often be helpful if you are in a similar situation.

PS. Though I haven't got to that point yet I've just started to read I Claudius by Rupert Graves, wherein Julius Caesar's 3rd wife Calpurnia makes an appearance. It seems a coincidence you posted today.
Aug 9 '18 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

14
by: JK Peck | last post by:
I have a fairly large Access application that ran correctly in Access 2000. After upgrading to Access 2003 (and recompiling and updating references), it reliably crashes at a certain point. If I...
13
by: Manuel Lopez | last post by:
I have a puzzling form timer problem that I didn't experience prior to Access 2003 (though I'm not sure access 2003 is to blame). Here's the situation: a computer has two access 2003 databases on...
0
by: jpatrick | last post by:
I had a very large number of query statements that I had converted to SQL a long time ago aticipating that I would some day upsize my application. Every now and then when I do an import to a new...
1
by: John Michael | last post by:
I have created some password routines to protect certain forms from access without a password. This allows me to create some security for apps that will be used on diff machines for users that...
7
by: Mike Nygard | last post by:
I'm experiencing extremely slow response times in design mode of my forms since moving to Access 2003. Simply dragging a button to a different position on the form takes 30 seconds or more. The...
2
by: Composer | last post by:
One form in my Access 2000 mdb causes a crash whenever I close it. The crash is of the type where I get a "Please tell Microsoft about this problem". Easy, you think! Well, here are the things...
2
by: Glyn | last post by:
Hi All, Access 2000 SR1 Windows XP SP2 Word 2000 I have a button on a form (frmMainMenu) that calls a second form (frmContractPrint). In the second form is a combo box (cboContractNumber)...
1
by: JohnMusbach | last post by:
Hi, I have a query that is being exported to XML. Everything works, except for expressions in the query such as: !!.! When the query is just opened normally, the expression works but when the...
2
by: Access | last post by:
Anyone else experiencing corruption problems using Access 2003 to edit .adp files? I've been experiencing corruption problems with a particular database. I've tried copying all the objects into a...
3
by: garfieldsevilla | last post by:
I have created a form which I want to launch from VBA. I tested the form in the Access UI and was able to roll through the table contents, editing and adding as required. I then added the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.