Re: Secured Database works exactly right on one computer, but on another not quite r

Chris Mills wrote:
It's nothing to do with "security setup and permissions".

She says it works fine on some PC's and not others. If it runs fine on some
PC's, then it is by-and-large set up correctly.

She obviously has different mdw's being implemented on different machines.
Even though they may be the same name and she thinks they're the same. That's
my call...
***I searched both machines for *.mdw....found only those for two other DB's
that I have security on and am using successfully on both machines, and on
the second machine...the one that works correctly, I found several system.mdw.
But if I try just opening the DB directly on the remote machine, without the
shortcut with the correct mdw, I get the message, "you don't have permission",
so I'm not defaulting to another mdw.

When I look at the users, I see exactly the same users on both machines. And
I added a user yesterday from my machine, and I see him on both machines. I
just don't think it's possible that both implementations aren't using the
same mdw.

I know this doesn't make any sense....

I have had this exact same implementation running successfully for several
years on ~ 15 computers at 2 other locations.....one BE, one mdw on a 'master
machine', and FE referencing them on all the others. I understand how it
needs to be set up. I just don't see how this is any different from that one,
and everything I found in other posts seems to be right. Still, it's not
working...

...because, she is happy with some machines and not others. That's a
difference in the files the machines are accessing, and nothing otherwise to
do with the complications of setting up Access Security.

(I cant tell from here whether it's a different mdb, mdw, shortcut, or
permissions on a folder, but it strikes me as one of those, rather than
whether she has "set up security correctly". It is up to her to establish the
precise difference between machines, which could be any of the above but NOT
basic security setup)
***I'm copying this mdb to the other machine. I'm referencing the ONLY copy
of Security.mdw on my network. The shortcut uses the COPIED mdb and the ONLY
mdw. I was using this DB for > 1 year successfully before implementing
security, so I don't see how it could be folder permissions...and it's in My
Documents, so that wouldn't be a problem.

Actually, if anything, the other machine is where I might expect problems...
it's an old machine, that has at one time had Access 95, 97, and 2000 on it
at the same time, and 2000 was upgraded to 2003. I know all the advice is
not to do that, but I was supporting DB's in all those versions, and it was a
bear to get set up initially. But I never had anything other than minor
annoyances with the multiple versions. But that is the machine that works!
The one I'm having problems with is relatively new, original installation of
XP, only ever had Office 2003....no glitches that I'm aware of.

She all but SAYS it's a difference of different files on different machines
***That's not what I intended to say...:>) That's the one thing I was
pretty sure was right from the beginning, because I've set up the same thing
at two other locations previously. I was hoping it would be something I had
done inadvertantly in the security that I'm not recognizing.

What it looks like to me is SOME difference between the machines, but the
setup seems to be right. And remember, I started out on my machine...the one
that doesn't work. What you'd expect to have trouble with is the remote
machine....

(well, as I see it, 50% chance of being wrong as usual!)
Chris

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200611/1

.

Relevant Pages

  • Re: the exploit that wasnt
    ... The other Mac Book Pro? ... brought Microsoft into a security discussion about Mac OS X. ... The number of security patches, ... if you were to scan random machines on the internet for a week, how many Unix machines do you believe you would hit? ...
    (comp.sys.mac.advocacy)
  • Re: Cryptogram Comment
    ... Or had to go through setting up basic security for their ... > bother me with Windows questions. ... > machines are broken. ... and Linux and other open OS's make all patches FREE to redistribute. ...
    (sci.crypt)
  • Re: Temporary Ban On Links In Posts To SRI
    ... understand that there is a risk when clicking ... low)" in the general case does not apply to SRI. ... implement the security measures recommended. ... update" even with machines that are restricted to only applications ...
    (soc.religion.islam)
  • Re: the exploit that wasnt
    ... The other Mac Book Pro? ... brought Microsoft into a security discussion about Mac OS X. ... The number of security patches, ... if you were to scan random machines on the internet for a week, ...
    (comp.sys.mac.advocacy)
  • Re: Small Business Server Networking Wizard was not installed
    ... IE browser helper toolbar with some sort of security features enabled. ... WINSOCK fix, all these things were done on both of these machines, nothing ... Server Networking Wizard would not run on and nothing helped. ... ActivX garbage to install on either of these two machines. ...
    (microsoft.public.windows.server.sbs)