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.
>> >> >
>> >> >
>> >>
>> >
>> >
>>
>
>