Problems creating MDE file

[SteveS]

I'm a relative newbie to Access, and am trying for the first time to add some
level of security to my new database. Unfortunately I seem to be unable to
create an MDE file. Every time I try, Access freezes (though I can open
another instance of it). When I use the "Create MDE file" tool it does create
a "db1.mdb" file, but no mde file. I'm running Access 2003, and have
compacted and repaired my database, which is just over 5MB. I have also
converted it to Access 2002-2003 format.

I want to create an MDE file so I can upload the database onto an internal
sharepoint site, where others can update their data. I'm more concerned about
protecting how the database works than the actual data itself, which is why I
thought an MDE might be best, but I'm open to other suggestions as well. HELP!

 

[Don Barton]

another instance of it). When I use the "Create MDE file" tool it does create
a "db1.mdb" file, but no mde file..

Steve,
Open the database, go into the VBA module (Alt-F11), menu Debug-

Compile databasename. Clear up any compiling errors, then try it.

Let us know if this works.

Don

 

[SteveS]

That did it! Thanks!!!

Now until I can figure out user level security I'll use the .mle file, hide
the queries etc. I don't want them to have direct access to, and use the
startup feature to try and keep them within the specified forms.

One other question though... when I'm ready to re-launch the database with
user level security, I should be able to update the .mdb database (with all
the exact same tables) with the information stored in the .mde file, right?
(I haven't really looked into this yet, but did read in passing about
updating tables through linking...)