John W. Vinson said:
Hold down the Shift key while you're
opening the database.
And, even if you wish to disable the Shift key, you can keep a "development
copy" that doesn't have all the Startup properties set, that you use for,
er, well, "developing" and then set the startup properties on a copy that
you distribute to the users; or, you can provide yourself an
unobvious-to-the-user "backdoor" (say, an innocuous-looking label, maybe
just one period in a label) that you can use to trigger code that sets the
bypass key back on. I prefer the former approach. I would rather not leave
an opportunity for a user to accidentally fall into design view.
Larry Linson
Microsoft Office Access MVP