Hi all,

A client recently changed the startup options for their database so that 
it would start with a main menu and disable the design view.  They had 
some problems and imported a new main menu form to replace the old one it 
was automatically opening upon startup.

However, now they can't save the form and Access does not let them modify 
the form name (from Main1 back to Main).  Plus, they now get all sorts of 
other errors related to this.

I verified this when they sent me a copy of their database.  It works 
great before changing the startup preferences and importing a main form 
to replace the old one.

Is this a known Access error?  I'd very much appreciate any help you can 
offer.  Thanks.

- Matt.

Matt,

<< I verified this when they sent me a copy of their database.  It works 
great before changing the startup preferences and importing a main form 
to replace the old one. >>

I once tried to use the start-up options to open up the database's main 
switchboard (main form) immediately upon the database opening.  That 
caused errors that were not there before. I turned this off and merely 
created an autoexec macro that did the same thing.  This worked.  I don't 
know why specifying a form to open in the start-up options did that, but 
it did.

Greg

Weird.  Thanks for sharing your experiences with this.  Even when I try 
renaming the form from main1 back to main, it will automatically change 
it back to main1 upon hitting enter.

Do you happen to still have the batch file you used?  It would be 
interesting learning more about going that route.  Thanks!

More confusing news...

My client decided to revert to a backup.  After a few hours of successful 
use, it suddenly gives "Module not found" errors all over the place when 
clicking buttons.  From what we could tell, all code was still associated 
just fine with the buttons.

This is really getting annoying.  Nothing was changed and suddenly things 
stop working.  I just wish Access would WORK.

Matt,

<< Do you happen to still have the batch file you used?  It would be 
interesting learning more about going that route. >>

Simply create a macro with one action:  OpenForm.  In the "Form Name" 
field at the bottom, but the form you want to open.  For "View" 
choose "Form" and for "Window Mode" choose "Normal".  Save that macro with 
the name "AutoExec".  Whenever you open that database, that form will open 
automatically.

Greg

Thanks Greg!  That's good to know.