Reuse Secured.MDW file?

31 Mar 2005 10:35 PM

JustinM

Hi,

I have a database that I've deployed on our network. After designing it, I
implemented user-level security and then manually split it (see
http://www.jmwild.com/SplitSecure.htm for a description of that).
Unfortunately, my frontend began behaving erratically (it appears corrupted),
so I need to replace it.

The only backup I have is the design database, which was saved previous to
the security implementation and subsequent split. Is there a way to reuse
the existing Secured.MDW file to secure the new frontend, or do I have to
start all over with the secure-and-split process? If I have to start over,
will the new "Secured.MDW" still work with the old backend?

Thanks in advance for your help!

31 Mar 2005 11:29 PM

Joan Wild

JustinM wrote:

> Hi,
>
> I have a database that I've deployed on our network. After designing
> it, I implemented user-level security and then manually split it (see
> http://www.jmwild.com/SplitSecure.htm for a description of that).
> Unfortunately, my frontend began behaving erratically (it appears
> corrupted), so I need to replace it.

What does behaving erratically mean? Perhaps you just need to repair it.
Have you tried Jetcomp available for download from MS?

> The only backup I have is the design database, which was saved
> previous to the security implementation and subsequent split. Is
> there a way to reuse the existing Secured.MDW file to secure the new
> frontend, or do I have to start all over with the secure-and-split
> process?

No need to start over. Join your secured.mdw file, create a new database
while logged in as the user who is to own all objects. Import all the
objects except the tables from your backup, and proceed to apply/deny
permissions to all the objects. Link to the tables in your existing
backend.

--
Joan Wild
Microsoft Access MVP

6 Apr 2005 8:39 PM

JustinM

I successfully rebuilt my frontend as described below - thanks, that's quite
the labor saver. However, I'm still getting the same errors. Whenever I
open a form that includes VBA code, I get the following error:

"The expression On Load you entered as the event property setting produced
the following error: Error accessing file. Network connection may have been
lost."

If I try to view the code, I get the same "Error accessing file" message.

Jetcomp errors out on the old frontend.

Thanks for your continued help,
Justin

Show quoteHide quote

"Joan Wild" wrote:

> JustinM wrote:
> > Hi,
> >
> > I have a database that I've deployed on our network. After designing
> > it, I implemented user-level security and then manually split it (see
> > http://www.jmwild.com/SplitSecure.htm for a description of that).
> > Unfortunately, my frontend began behaving erratically (it appears
> > corrupted), so I need to replace it.
>
> What does behaving erratically mean? Perhaps you just need to repair it.
> Have you tried Jetcomp available for download from MS?
>
> > The only backup I have is the design database, which was saved
> > previous to the security implementation and subsequent split. Is
> > there a way to reuse the existing Secured.MDW file to secure the new
> > frontend, or do I have to start all over with the secure-and-split
> > process?
>
> No need to start over. Join your secured.mdw file, create a new database
> while logged in as the user who is to own all objects. Import all the
> objects except the tables from your backup, and proceed to apply/deny
> permissions to all the objects. Link to the tables in your existing
> backend.
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
>

6 Apr 2005 8:51 PM

Joan Wild

"JustinM" <Just***@discussions.microsoft.com> wrote in message
news:BCF9600B-5F3A-44A1-B922-C13B93C58711@microsoft.com...
>I successfully rebuilt my frontend as described below - thanks, that's
>quite
> the labor saver. However, I'm still getting the same errors. Whenever I
> open a form that includes VBA code, I get the following error:
>
> "The expression On Load you entered as the event property setting produced
> the following error: Error accessing file. Network connection may have
> been
> lost."

It's important that you are up to date with all service releases and
patches. This issue was fixed with SP3. When you import objects, it's
important to open any code module and Compile (Debug menu). See
http://support.microsoft.com/kb/304548/

--
Joan Wild
Microsoft Access MVP

6 Apr 2005 9:47 PM

JustinM

Thanks! I went through the aforementioned process again and compiled before
I exited. The errors are thus gone. Now I get to bug my IT people to
install the service packs...

Thanks again,
Justin

Show quoteHide quote

"Joan Wild" wrote:

>
> "JustinM" <Just***@discussions.microsoft.com> wrote in message
> news:BCF9600B-5F3A-44A1-B922-C13B93C58711@microsoft.com...
> >I successfully rebuilt my frontend as described below - thanks, that's
> >quite
> > the labor saver. However, I'm still getting the same errors. Whenever I
> > open a form that includes VBA code, I get the following error:
> >
> > "The expression On Load you entered as the event property setting produced
> > the following error: Error accessing file. Network connection may have
> > been
> > lost."
>
> It's important that you are up to date with all service releases and
> patches. This issue was fixed with SP3. When you import objects, it's
> important to open any code module and Compile (Debug menu). See
> http://support.microsoft.com/kb/304548/
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
>