Reuse Secured.MDW file?

[Guest]

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!

 

[Joan Wild]

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.

 

[Guest]

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

 

[Joan Wild]

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/

 

[Guest]

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