Thanks, Kerry.
I totally believe you when you say "security is a complicated thing". I
don't know much about computers, but I do know that what goes on behind a
simple point and click button on a user's screen is very, very complicated.
Just seems to me that Microsoft could have designed a much clearer and
easier to use interface between all of this complicated stuff and what the
user wishes to do.
-- I'm getting older, and the learning curve for new operating systems seems
to be getting steeper!
"Kerry Brown" <kerry@kdbNOSPAMsys-tems.c*a*m> wrote in message
news:eWN1ul03HHA.1188@TK2MSFTNGP04.phx.gbl...
> Unfortunately security is a complicated thing. In NT based versions of
> Windows there has never been an easy way to say "This folder is safe". You
> have to use user accounts combined with NTFS permissions. In previous
> versions of Windows everyone ran as an administrator account. This lead to
> many poor programming practices. Vista enforces security and breaks many
> things that used to work. The reason it breaks them is because the
programs
> assume the user can do anything. I suspect that all you have to do is set
> the NTFS permissions on the C:\Access97 folder but I could be wrong.
> Microsoft has also been guilty of poor programming in the past and many
> older Microsoft programs have problems with the security in Vista. Access
> 2000/2002 is an old program. I highly recommend you post these questions
in
> the Access newsgroup. There are Access experts there who will know if it's
> an Access problem or just a permissions problem.
>
> --
> Kerry Brown
> Microsoft MVP - Shell/User
> http://www.vistahelp.ca
>
>
> "FPS, Romney" <fpswv@citlink.net> wrote in message
> news:OjeMJ4x3HHA.5724@TK2MSFTNGP05.phx.gbl...
> > Thanks for the response, Kerry.
> > But, this is Access 2000/2002. You may be right that this is an Access
> > problem, but it's not an older version of Access. I believe it's simply
a
> > question of telling Vista that it's safe to copy a file from a specific
> > folder on a mapped drive on the LAN. (In a separate matter, I did run
into
> > a
> > problem trying to re-install an older version of Access (Access 97) on a
> > replacement computer that was updated[??] to Vista. Access 97 installed
> > fine, but SR2 was unable to complete its installation. I'll post that
> > problem to the Access newsgroup).
> >
> > I haven't had a chance to read through the links you provided, but isn't
> > there a simple way to point to a specific folder or location on the
> > network
> > and designate this as "safe"? Meanwhile, leaving UAC turned off allows
the
> > database to copy from that mapped drive/folder without any problem.
> >
> > Thank you.
> > Mark
> > "Kerry Brown" <kerry@kdbNOSPAMsys-tems.c*a*m> wrote in message
> > news:eig1zCo3HHA.4184@TK2MSFTNGP06.phx.gbl...
> >> NTFS is the basis for file security in all NT based versions of Windows
> >> going back to Windows NT. I know that older versions of Access have
some
> >> problems with how UAC affects this in Vista. You may want to repost
this
> >> question on the access newsgroup - microsoft.public.access
> >>
> >> --
> >> Kerry Brown
> >> Microsoft MVP - Shell/User
> >> http://www.vistahelp.ca
> >>
> >>
> >> "FPS, Romney" <fpswv@citlink.net> wrote in message
> >> news:%23KHDS%23l3HHA.1164@TK2MSFTNGP02.phx.gbl...
> >> > Kerry,
> >> > I don't know what NTFS security is, but thanks for the links -- I
guess
> >> > I'll
> >> > have to take the time to learn about it.
> >> > The path to the local folder is C:\Access97. ("Access97" is just the
> > name
> >> > of
> >> > the folder).
> >> >
> >> > Further info:
> >> > Vista is on a laptop which occasionally plugs into our LAN.
> >> >
> >> > The laptop has a local copy of the frontend and backend databases.
> >> > These
> >> > databases are stored in C:\Access97 on the laptop.
> >> >
> >> > Also on the laptop is an icon for the shared network folder. This is
a
> >> > password protected folder and has been mapped on the laptop as
> >> > "p:\sharedfolder\". This shared folder resides on an XP machine.
> >> >
> >> > The user plugs into our LAN for several reasons:
> >> > 1. To use the internet (no problem)
> >> > 2. To use the network printer (no problem)
> >> > 3. To transfer stuff from their database to the network database
> >> > located
> >> > at
> >> > "p:\sharedfolder\database.mdb" (no problem).
> >> > -- in order to transfer stuff to the network database, the user first
> > logs
> >> > onto "p:\sharedfolder\" by double-clicking their desktop icon and
> > entering
> >> > the correct username and password. Once they're logged on, they can
> >> > transfer
> >> > stuff from their database into the main system.
> >> > 4. With WinXP, the user could also update their own database by first
> >> > logging into "p:\sharedfolder\" as described above, and then clicking
a
> >> > button in their database which would then copy "database.mdb" from
> >> > "p:\sharedfolder\" and replace their older copy on their laptop (this
> >> > is
> >> > the
> >> > part that no longer works).
> >> >
> >> > I guess I need to take the time to read the two links you supplied.
(I
> >> > think
> >> > Microsoft could have made this task a lot easier for the user to find
> > out
> >> > what they needed to do -- more obvious buttons, prompts, or options
> > when
> >> > you right-click a file or folder, for example).
> >> >
> >> > Thanks again for your help.
> >> > Mark
> >> >
> >> > "Kerry Brown" <kerry@kdbNOSPAMsys-tems.c*a*m> wrote in message
> >> > news:OrfznXg3HHA.3916@TK2MSFTNGP02.phx.gbl...
> >> >> You probably have to set the NTFS security for both folders. What is
> > the
> >> >> path to the folder on the local computer? Depending where it is you
> >> >> may
> >> > need
> >> >> to take ownership as well.
> >> >>
> >> >>
> >> >
> > http://windowshelp.microsoft.com/win...=ntfs+security
> >> >>
> >> >>
> >> >
> > http://windowshelp.microsoft.com/Win...973031033.mspx
> >> >>
> >> >> --
> >> >> Kerry Brown
> >> >> Microsoft MVP - Shell/User
> >> >> http://www.vistahelp.ca
> >> >>
> >> >>
> >> >> "FPS, Romney" <fpswv@citlink.net> wrote in message
> >> >> news:O%23ng3hc3HHA.5980@TK2MSFTNGP04.phx.gbl...
> >> >> > Hi Kerry,
> >> >> > I'm copying to the same folder in which the database resides.
> >> >> >
> >> >> > BTW: It's a "split" database. The desktop icon opens the frontend
> >> >> > database,
> >> >> > which then looks for the data in a separate database, which in
this
> >> >> > case
> >> >> > happens to be located in this same folder. When I first tried to
> > open
> >> > the
> >> >> > database on this new computer, I had to tell Vista to "trust" this
> >> > folder
> >> >> > and the files/programs within that folder in order for the
frontend
> >> >> > database
> >> >> > to be able to access the data in the backend database. There was
an
> >> > option
> >> >> > in one of the Vista message boxes to go to the "Trust Center".
Once
> >> >> > I
> >> > did
> >> >> > that, I could then specify this folder and its contents as
> >> >> > "trusted".
> > I
> >> >> > thought I could find this "Trust Center" and then point to the
> >> >> > shared
> >> >> > network folder, but no luck.
> >> >> >
> >> >> > "Kerry Brown" <kerry@kdbNOSPAMsys-tems.c*a*m> wrote in message
> >> >> > news:uFJxDDc3HHA.4880@TK2MSFTNGP03.phx.gbl...
> >> >> >> Where on the local computer are you copying to? The location on
the
> >> > local
> >> >> >> computer is more likely to cause the problem.
> >> >> >>
> >> >> >> --
> >> >> >> Kerry Brown
> >> >> >> Microsoft MVP - Shell/User
> >> >> >> http://www.vistahelp.ca
> >> >> >>
> >> >> >>
> >> >> >> "FPS, Romney" <fpswv@citlink.net> wrote in message
> >> >> >> news:uFo%23Wsb3HHA.1188@TK2MSFTNGP04.phx.gbl...
> >> >> >> > Hi,
> >> >> >> > I have a Microsoft Access database running on a local Vista
> > computer
> >> >> > that
> >> >> >> > uses code to copy a file from a shared network folder. If I
turn
> > off
> >> >> >> > UAC
> >> >> >> > on
> >> >> >> > the local computer, the code works fine ... the file is copied
> > from
> >> > the
> >> >> >> > shared network folder to this particular computer. If UAC is
left
> >> >> >> > on,
> >> >> > the
> >> >> >> > code runs without any alerts or error messages, but the file
has
> > not
> >> >> > been
> >> >> >> > copied.
> >> >> >> >
> >> >> >> > How do I have Vista treat this shared network folder as a
> > "trusted"
> >> >> > site?
> >> >> >> > Thank you.
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >
> >> >> >
> >> >>
> >> >
> >> >
> >>
> >
> >
>