Re: Database Options - Any other settings I should adjust?

"'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@xxxxxxxxxxxxxxxxxxxxxx>
wrote in nf8Li.3$n92.1@trnddc06:">news:nf8Li.3$n92.1@trnddc06:

Ensure Option Explicit is set in the Declarations area of every
module, "Require Variable Declaration" is checked, "Compile on
Demand" is not checked,

These are all in the VBE options (something that always trips me up,
as I still frequently program in A97).


It's best to have custom menus instead of the built-in menus so
that you control what the users do when using the application.

I disagree with this. It depends on the application and the users. I
have only ever had two apps with custom menus/toolbars, and they
were a pain to work with (I eventually set it up so that when I was
working both the custom and standard toolbars displayed).


It's also usually
best to convert to an MDE and distribute the MDE database file,
not the MDB database file

This is another piece of common wisdom that I ignore. I've only one
case where I make sure the user has an MDE, and that's because she
has a tendency to type through the occasional unhandled error
message. Thus, I never hear about the error (she didn't see it), and
I end up being called in to revert the code she typed into to its
compilable state. So, she gets an MDE. All my other users have MDBs,
and it's Just Fine.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: 2007 Installation
    ... I encountered the exact same problem after installing Access 2007 alongside ... pre-compiled mde. ... The solution is to compile the 2002 mdb into an mde using the 2007 ... I have an exe that opens an Access "portal" ...
    (microsoft.public.access.setupconfig)
  • Re: 2007 Installation
    ... I encountered the exact same problem after installing Access 2007 alongside ... pre-compiled mde. ... The solution is to compile the 2002 mdb into an mde using the 2007 ... I have an exe that opens an Access "portal" ...
    (microsoft.public.access.setupconfig)
  • Re: MDE not possible ?
    ... First compile the MDB and make sure that there are no errors in the code ... before creating the MDE. ... Because of the methode used to compile the database a lot of references ... If your database is in Access 2000 file format (it should say on ...
    (microsoft.public.access.formscoding)
  • Re: Secure Payroll information w/o using Access Security
    ... "Joan Wild" wrote: ... compile, followed by Save). ... I thought the MDE would be a good approach, but I tried to create an MDE ... "This error is usually associated with compiling a large database into ...
    (microsoft.public.access.security)
  • Re: Secure Payroll information w/o using Access Security
    ... compile, followed by Save). ... I thought the MDE would be a good approach, but I tried to create an MDE ... "This error is usually associated with compiling a large database into ... Create a startup form that is opened ...
    (microsoft.public.access.security)