Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Security / July 2008

Tip: Looking for answers? Try searching our database.

One workgroup file for frontend and backend not updating

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
heidii - 23 Jun 2008 23:44 GMT
Hello All:

I have hit a snag.

I have a Database with a FrontEnd, BackEnd and a Seond Front End,
called Master that I do changes on.

I used to be able to into the Master FrontEnd and make permission
changes to groups, then Log Into the Regular Front End and see the
permission changes I did.

Now when I log into the Regular Front End and the changes are not
there.  I seem to have to completely overwrite the file with a new
copy to see any changes.

I have double and triple checked my shortcuts and which workgroup they
are pointing to.  Everything is the same.

Any ideas from anybody on what could have changed.

Thanks much

Heidi
Joan Wild - 24 Jun 2008 00:25 GMT
: I have a Database with a FrontEnd, BackEnd and a Seond Front End,
: called Master that I do changes on.
:
: I used to be able to into the Master FrontEnd and make permission
: changes to groups, then Log Into the Regular Front End and see the
: permission changes I did.

No you didn't.  The permissions are stored in the mdb file.  You might have added a user, or changed the groups a user was a member of (that is stored in the mdw), and seen the change, but not permissions.

: Now when I log into the Regular Front End and the changes are not
: there.  I seem to have to completely overwrite the file with a new
: copy to see any changes.

Yes, that's the only way.

Signature

Joan Wild
Microsoft Access MVP

heidii - 24 Jun 2008 17:39 GMT
To your comment-
"You might have added a user, or changed the groups a user was a
member of (that is stored in the mdw), and seen the change, but not
permissions."

That is what I did.  I added a new user and then added them to certain
groups.  Those changes are not showing reflected into the other front
end.

> : I have a Database with a FrontEnd, BackEnd and a Seond Front End,
> : called Master that I do changes on.
[quoted text clipped - 14 lines]
> Joan Wild
> Microsoft Access MVP
Joan Wild - 25 Jun 2008 01:36 GMT
If that's the case, then you are using a different mdw with 'the other frontend'

Signature

Joan Wild
Microsoft Access MVP

To your comment-
"You might have added a user, or changed the groups a user was a
member of (that is stored in the mdw), and seen the change, but not
permissions."

That is what I did.  I added a new user and then added them to certain
groups.  Those changes are not showing reflected into the other front
end.

On Jun 23, 4:25 pm, "Joan Wild" <jw...@nospamtyenet.com> wrote:
> "heidii" <hei...@zirklefruit.com> wrote in messagenews:6902e170-bd3e-4eba-abe8-9a45eb36cc74@w1g2000prd.googlegroups.com...
>
[quoted text clipped - 16 lines]
> Joan Wild
> Microsoft Access MVP
a a r o n _ k e m p f - 28 Jun 2008 16:36 GMT
sounds to me like it's just a flaky a.s setup.

Move to SQL Server if you care about security.
Case closed.

-Aaron

> If that's the case, then you are using a different mdw with 'the other frontend'
>
[quoted text clipped - 32 lines]
> > Joan Wild
> > Microsoft Access MVP
heidii - 03 Jul 2008 00:54 GMT
On Jun 28, 8:36 am, a a r o n _ k e m p f <aaron_ke...@hotmail.com>
wrote:
> sounds to me like it's just a flaky a.s setup.
>
> Move to SQL Server if you care about security.
> Case closed.
>
> -Aaron

Yes SQL is better @ security but..  This is a newsgroup for helping
others find answers to problems, not trashing people with unfactuated
opinions, Your Quote - ("sounds to me like it's just a flaky a.s
setup.")

Thanks to the other helpful people.
Joan Wild - 03 Jul 2008 15:03 GMT
Thanks to the other helpful people.

You're welcome

Signature

Joan Wild
Microsoft Access MVP

Keith Wilby - 03 Jul 2008 16:00 GMT
"a a r o n _ k e m p f " is a sad individual who gains pleasure from
trolling the Access newsgroups.  "a a r o n _ k e m p f " is the proverbial
"broken record", repeating the same worthless garbage over and over.  "a a r
o n _ k e m p f " should be ignored.
heidii - 07 Jul 2008 21:03 GMT
> "a a r o n _ k e m p f " is a sad individual who gains pleasure from
> trolling the Access newsgroups.  "a a r o n _ k e m p f " is the proverbial
> "broken record", repeating the same worthless garbage over and over.  "a a r
> o n _ k e m p f " should be ignored.

why has he not been booted or banned by moderators?
Douglas J. Steele - 07 Jul 2008 22:11 GMT
Because there ARE no moderators for these newsgroups.

While Microsoft has, on occasion, deleted his posts from their server, the
fact that the newsgroups are replicated on thousands of other servers makes
it impossible to delete his posts from every server that carries these
newsgroups.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

why has he not been booted or banned by moderators?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.