Re: Correct Sequence?

It's something I have a tendency to forget as well. 2000 and 2002 don't set
a reference to DAO by default. When you create a new mdb, you have to set
that reference (and often uncheck the ADO reference)

--
Joan Wild
Microsoft Access MVP

Ian wrote:
Joan, thank very much, you're a hero.

I think what happened was that when I created a new db and imported
in my old objects so I was the owner the Reference to the DAO library
was lost and so Access couldn't recognise my DAO code. I've learnt a
valuable lesson to compile regularly to resolve problems.

Thanks again,
Ian.


"Joan Wild" wrote:

Open the MDB and hit Ctrl-G; Debug menu, Compile.

Fix any errors that it finds. Compile again, save.

In Access, Tools Database Utilities, Compact and Repair.

Now try to create the MDE.


--
Joan Wild
Microsoft Access MVP

Ian wrote:
Joan,

Finally worked my way through the maze that is Security, but not
convinced I've got it fully yet!! I followed your sequence and tried
to make the MDE file but Access won't do it. I get an error message
saying Access is unable to make the MDE file. I tried a couple of
times but the same thing.

Sorry to hassle you but any suggestions?

Thanks,
Ian.

"Joan Wild" wrote:

I would
split
secure the frontend mdb
use the same workgroup file to secure the backend mdb
make the frontend into mde and distribute

any changes you need to make you do in the mdb. Once tested, you
create a mde and distribute.


--
Joan Wild
Microsoft Access MVP

Ian wrote:
Can someone please enlighten me as to the correct sequence of
events in preparing to secure a db. Once I have my db completed
and ready to be run (over a network), should I split the db into
FE and BE, then make the FE an MDE. At this point do I then
create my new workgroup information file and set up the security
I need.

Thanks for your continued support,

Ian.


.

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: creating external references
    ... The easiest way to implement this is with a referenced MDE. ... Then 'compile' it into an MDE and set a reference in your other ... deploy the frontends as MDBs (because an MDB will recompile against the new ... DLL, which means that all class GUIDs remain the same after a rebuild. ...
    (microsoft.public.access.modulesdaovba)
  • Re: expose class modules of a referenced mde
    ... Since I can't reference an .mdb from an .mde (which is what the final ... reference file and import the class objects as needed into the app. ...
    (comp.databases.ms-access)
  • Re: Function name not found
    ... certain Reference changes from version to version in MDBs, ... format (MDB is still fine) on the affected PC. ... Is there a way to check the pre-compiled MDE ... Looking at you Startup function, the first thing I see is a DFirst ...
    (microsoft.public.access.modulesdaovba)
  • Re: Common Code
    ... You can put your "common code" in an mde, and then set a Reference to that mde from the other apps. ... Steve Schapel, Microsoft Access MVP ...
    (microsoft.public.access.macros)