Re: Correct Sequence?

Tech-Archive recommends: Fix windows errors by optimizing your registry

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: Secure Payroll information w/o using Access Security
    ... Thanks for the suggestions Joan - I'll give them a try. ... I thought the MDE would be a good approach, but I tried to create an MDE and ... Maybe a way I could split this info off from the main database (A ... Create a startup form that is opened on ...
    (microsoft.public.access.security)
  • Re: MDE file security
    ... Not in an MDE surely? ... This will take you into the design view of the form. ... that but you can make and save changes to the design - no code changes of ... Joan Wild ...
    (microsoft.public.access.modulesdaovba)
  • Re: Direction needed with a field conundrum
    ... > What clouds the subject slightly is that this is for a small county ... > Wild, Joan ... Where is John and his examples - How do you know for certain that Joan Wild ... it was George Forman who name all his sons George, and they live in the same ...
    (microsoft.public.access.tablesdbdesign)
  • Re: FAO Duane Hookom (Coding Issues)
    ... Thanks Joan. ... in the templates, not to get stuck on a URL. ... "Joan Wild" wrote in message ... >>> Recipe collection database ...
    (microsoft.public.access.modulesdaovba)
  • Re: Cant find old post - Command Button Visible
    ... Joan, Thank goodness you found my post! ... "Joan Wild" wrote: ... >> Private Sub Form_Open ... >> Select Case fOSUserName() ...
    (microsoft.public.access.security)