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

I second that! If you're working for a company and just distributing an app in-house, you could use the .mdb, but if you're distributing an app globally, .mde is the way to go.


"Steve" <steve@xxxxxxxxxx> wrote in message news:bJuLi.20$gu2.13@xxxxxxxxxxxxxxx

"David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx> wrote in message news:Xns99B9DEB6D9E2Bf99a49ed1d0c49c5bbb2@xxxxxxxxxxxxxxxxx
"'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@xxxxxxxxxxxxxxxxxxxxxx>
wrote in nf8Li.3$n92.1@trnddc06:">news:nf8Li.3$n92.1@trnddc06:

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.


I always distribute the front end as an MDE. It adds a level of security and control, that you don't get with an MDB. There is no reason not too.

Steven


.

Relevant Pages

  • Re: Lock / Unlock VBA project
    ... "Alex Dybenko" wrote: ... make MDE? ... library MDB - create ne mdb, import forms/modules from your app, which ... have to make MDE of it and add reference to library MDE in order to make MDE ...
    (microsoft.public.access.modulesdaovba)
  • Re: Converting Access 97 MDE to Access 2003
    ... what is the MDB front-end you are ... The mdb front end is of course the original mdb you had to make the mde. ... ms-access is the in the SAME VERSION as what you are developing under. ... a mde file is created by going tools->database utile. ...
    (microsoft.public.access.conversion)
  • Possible Fix for "Unable to create MDE" Error and "Unexpected Error 40230" in Access 2002
    ... compile it and create an MDE on the local disk. ... With each one I progressively deleted more and more objects in the mdb until ... Dev PC is WinXP SP1. ...
    (microsoft.public.access.conversion)
  • Re: importing report from mde to mdb
    ... One cannot import reports from an MDE database file or into an MDE database ... MDE database file using the Import Wizard, then you are using an MDB ...
    (microsoft.public.access.conversion)
  • Re: 5 access 2000 users and 1 AccessXP user
    ... > Making the user an administrator on the local machine worked for the case ... > it to th PC (it is an mde file). ... The back end is on a server running win2K ... locate the front end mdb file on the ...
    (microsoft.public.access.conversion)