Help-2003 Access (Not Responding) hoses up when create MDE File an

[TxBlueEyes]

Hi all,

Well, I have 2 questions - Question 1 - Must I create an MDE for my 2 shared
databases.. They are split - 2 FEs linked to 1 BE(houses all the table)...
Both are saved on our Company Public drive, in a folder that I have
structured with allowing only specific employees with Permissions to the
folder. We all use the same networked drive (P... Currently there is no
ACCESS User-Level Security set on either FEs.... 1 FE is for generating and
printing reports, and 1 FE is for entering the data(I call this the
production DB)... 20 users in all will use the databases, all ACCESS
novices... Question 2 - every time I have tried to convert the MDB files to a
MDE file access hoses up, and stops responding... I totally debugged, and
only found one discrempancy which was corrected, and then I was able to
convert to MDE, or so I thought until it hosed up... Any suggestions... I
don't have time to keep trying to convert to MDE Files. So what would be
another possibility... TEX....

 

[Douglas J. Steele]

No, you don't have to create MDEs. It's generally recommended since it
prevents your users from making changes to your application, either
deliberately or accidentally.

See whether there's any relevant to your problem in
http://www.access.qbuilt.com/html/conversion.html#CannotMakeMDE

 

[TxBlueEyes]

Hey there Douglas,

YAhoo, I got it to work... I was in the wrong file, like an idiot tried to
convert the BAK file that still had the original Tables... DUH! Stuck on
Stupid (SOS). Once I was in the right FE with the Linked Tables to the Be, it
worked Fine... simple enough... I agree reading more on the benefits of doing
a MDE... So I think going with an MDE is a smart way to go... So Douglas let
me know If I have this right.... Since I have the main FEs, BE, and MDE in
the Permission protected folder, then all I have to do is have the users go
into the folder - right click on the MDE file rightclick - click Copy, and
then just paste to their Desktop... Or am I making it too simple... I tested
on my desktop and it worked fine, it didn't allow any Design modifications to
the forms, just to the queries... which is fine... Many Thank, TxBlueEyes...
;o)

 

[Tom Wickerath]

Hi Tex,

My suggestion is to use Access MVP Tony Toews' free AutoFE Updater Utility,
instead of trying to rely on your users copying the FE .mde file to their
local hard drives. My experience is that some users will simply double-click
the .mde file and run it from the file server, which is not what you want to
happen. You can find this utility here:

Auto FE Updater
http://www.granite.ab.ca/access/autofe.htm

along with a pretty good getting started tutorial, if I do say so myself
<smile>, here:

Getting started with the Auto FE Updater
http://www.granite.ab.ca/access/autofe/gettingstarted.htm

I would remove the development copy (.mdb) from the shared file server, and
just keep that on your local hard drive, plus, of course, back it up wherever
you are normally backing up all your other work.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________