first use of switchboard select option when app is first loaded

[Guest]

If I select the first option button when my switchboard(default) I get the
message from micrsoft that an error has occured with the option to send them
the data generated by the error. I've done this over 50 times and am a bit
pissed. If I select any other option button everything works fine even when I
go back to the first option button. This is a real pain as I use my app daily
and am unable to distribute to others who have a real need for my app. Heres
some info I found:



I also found this info concerning the above:

AppName: msaccess.exe AppVer: 11.0.6566.0 AppStamp: 42cdb33e ModName:
vbe6.dll ModVer: 6.4.99.72 ModStamp: 40b29ba6

fDebug: 0 Offset: 000041a4

As this is the startup form, I have no way to set a code break so I can
step through the code!

I am using MSAccess 2003

Any help would be appreciated.
Thank you,
Bart Moss

 

[Allen Browne]

Can certainly understand your frustration, so will try to help with some
suggestions. You may already have tried some of these.

1. When you start the program, hold down the Shift key. This bypasses any
autoexec macro, does not load the startup form, and gives you the default
toolbars and menus. You can now disable the startup form until you get this
solved:
Tools | Startup
(It this does not work, you may need to set the AllowBypassKey property
programmatically.)

2. Now that the database is not crashing as soon as it starts, you can work
on fixing the problem. Start with the built-in compact and repair:
Tools | Database Utilities | Compact/Repair

3. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Then compact again.
Explanation of why:
http://allenbrowne.com/bug-03.html

4. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

5. Open Access, and compact again.

6. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

7. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

At this point, you should have a database where the name-autocorrect errors
are gone, the indexes are repaired, inconsistencies between the text- and
compiled-versions of the code are fixed, reference ambiguities are resolved,
and the code syntax is compilable.

If it is still a problem, the next step would be to get Access to rebuild
the database for you. Follow the steps for the first symptom in this
article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html