dbTalk Databases Forums  

Security goes away when someone refreshes the Front End

comp.databases.ms-access comp.databases.ms-access


Discuss Security goes away when someone refreshes the Front End in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
abprules
 
Posts: n/a

Default Security goes away when someone refreshes the Front End - 11-27-2007 , 04:16 PM






Help!!! This is driving me nuts!

We have created a DB for a company. We split the DB. Everything seems
to work well except for this one thing.

Every time we refresh the front end of a user, the security file
looses all security that was set. Each user has a desktop shortcut
that they access their front end from. The front end points to the
back end that resides on a computer. The security file is there as
well.

We have had to redo the security at least 20 times and I know there
must be something small that we are missing.

Can anyone please make suggestions?

Thanks.

Reply With Quote
  #2  
Old   
Tom van Stiphout
 
Posts: n/a

Default Re: Security goes away when someone refreshes the Front End - 11-27-2007 , 07:59 PM






On Tue, 27 Nov 2007 14:16:34 -0800 (PST), abprules <abprules (AT) aol (DOT) com>
wrote:

Your shortcut should include the workgroup file:
<path_to>msaccess.exe <path_to>frontend.mdb /wrkgrp <path_to>some.mdw

-Tom.


Quote:
Help!!! This is driving me nuts!

We have created a DB for a company. We split the DB. Everything seems
to work well except for this one thing.

Every time we refresh the front end of a user, the security file
looses all security that was set. Each user has a desktop shortcut
that they access their front end from. The front end points to the
back end that resides on a computer. The security file is there as
well.

We have had to redo the security at least 20 times and I know there
must be something small that we are missing.

Can anyone please make suggestions?

Thanks.

Reply With Quote
  #3  
Old   
Keith Wilby
 
Posts: n/a

Default Re: Security goes away when someone refreshes the Front End - 11-28-2007 , 02:23 AM



"abprules" <abprules (AT) aol (DOT) com> wrote

Quote:
Help!!! This is driving me nuts!

We have created a DB for a company. We split the DB. Everything seems
to work well except for this one thing.

Every time we refresh the front end of a user, the security file
looses all security that was set. Each user has a desktop shortcut
that they access their front end from. The front end points to the
back end that resides on a computer. The security file is there as
well.

We have had to redo the security at least 20 times and I know there
must be something small that we are missing.

Can anyone please make suggestions?

It sounds like you might have missed one or more steps in the securing
process. You need to follow every step in the FAQ (link on my web site) in
the order stated, omitting nothing, no matter how unimportant it might seem.
There's also a step-by-step example on my web site which might help.

Regards,
Keith.
www.keithwilby.com



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.