I am having an issue with MS Access. Here is the situation: We
keep all of our backend and front end mdb files on a network
share that only myself and a few other database designers have
permissions beyond read and file scan. To deploy databases we
copy an MDE file from the network onto a user's local HD. The
user can usually access the MDE file with no trouble but it is 'read only'
mode on the user's computer.
A workaround is to give the user local admin rights to the computer where
the mde file is stored on the rights. Which is a pain as I am using roaming
profiles and some users ignore the read only warning and their days work is
lost.
Thanks in advance.

If you can't copy the mde to a folder the user can write to (needs read,
write and update, and delete would probably be helpful for the ldb file), you
need a separate folder for each user on the network where the mde front end
stays while the user wanders from pc to pc with those roaming profiles.

Chris
Microsoft MVP


BrianMultiLanguage wrote:
>I am having an issue with MS Access. Here is the situation: We
>keep all of our backend and front end mdb files on a network
>share that only myself and a few other database designers have
>permissions beyond read and file scan. To deploy databases we
>copy an MDE file from the network onto a user's local HD. The
>user can usually access the MDE file with no trouble but it is 'read only'
>mode on the user's computer.
>A workaround is to give the user local admin rights to the computer where
>the mde file is stored on the rights. Which is a pain as I am using roaming
>profiles and some users ignore the read only warning and their days work is
>lost.

--
Message posted via http://www.accessmonster.com

And make sure the user has read, write and update (probably delete too, for
the ldb file) on that network folder.

Doesn't their profile give them a user data folder where they can save data
on the pc (folder has write and update permissions)?

Chris
Microsoft MVP


Chris O'C wrote:
>If you can't copy the mde to a folder the user can write to (needs read,
>write and update, and delete would probably be helpful for the ldb file), you
>need a separate folder for each user on the network where the mde front end
>stays while the user wanders from pc to pc with those roaming profiles.
>
>Chris
>Microsoft MVP

--
Message posted via http://www.accessmonster.com

SO don't copy it to the pc but to their roaming profile dir?


"Chris O'C via AccessMonster.com" wrote:

> If you can't copy the mde to a folder the user can write to (needs read,
> write and update, and delete would probably be helpful for the ldb file), you
> need a separate folder for each user on the network where the mde front end
> stays while the user wanders from pc to pc with those roaming profiles.
>
> Chris
> Microsoft MVP
>
>
> BrianMultiLanguage wrote:
> >I am having an issue with MS Access. Here is the situation: We
> >keep all of our backend and front end mdb files on a network
> >share that only myself and a few other database designers have
> >permissions beyond read and file scan. To deploy databases we
> >copy an MDE file from the network onto a user's local HD. The
> >user can usually access the MDE file with no trouble but it is 'read only'
> >mode on the user's computer.
> >A workaround is to give the user local admin rights to the computer where
> >the mde file is stored on the rights. Which is a pain as I am using roaming
> >profiles and some users ignore the read only warning and their days work is
> >lost.
>
> --
> Message posted via http://www.accessmonster.com
>
>

If the roaming profile folder is copied from the network to the pc for the
day, that would be ideal. But the thing is the user needs read, write,
update (and possibly delete) permissions on the folder where the mde is
copied to for the day. For performance reasons that folder should be on the
user's pc, but if that's not possible a network folder is acceptable.

Chris
Microsoft MVP


BrianMultiLanguage wrote:
>SO don't copy it to the pc but to their roaming profile dir?
>
>> If you can't copy the mde to a folder the user can write to (needs read,
>> write and update, and delete would probably be helpful for the ldb file), you
>[quoted text clipped - 15 lines]
>> >profiles and some users ignore the read only warning and their days work is
>> >lost.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200809/1

BrianMultiLanguage <BrianMultiLanguage@discussions.microsoft.com>
wrote:

>I am having an issue with MS Access. Here is the situation: We
>keep all of our backend and front end mdb files on a network
>share that only myself and a few other database designers have
>permissions beyond read and file scan. To deploy databases we
>copy an MDE file from the network onto a user's local HD. The
>user can usually access the MDE file with no trouble but it is 'read only'
>mode on the user's computer.

Where do you copy the file to? Program files? Don't as that is read
only to regular users.

Instead use %app data%\<your app name> which is usually C:\Documents
and Settings\ttoews\Application Data\<your app name> in Windows XP.
Different in Windows Vista.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Or, if you are using roaming profiles and don't want the MDE to roam,
to "Local AppData", which is usually

C:\Documents and Settings\..user name..\Local Settings\Application Data\

in Windows XP.


(david)

> Instead use %app data%\<your app name> which is usually C:\Documents
> and Settings\ttoews\Application Data\<your app name> in Windows XP.

"Tony Toews [MVP]" <ttoews@telusplanet.net> wrote in message
news:s15cc4luiavijbkj1rmuurmc7i9carsteo@4ax.com...
> BrianMultiLanguage <BrianMultiLanguage@discussions.microsoft.com>
> wrote:
>
>>I am having an issue with MS Access. Here is the situation: We
>>keep all of our backend and front end mdb files on a network
>>share that only myself and a few other database designers have
>>permissions beyond read and file scan. To deploy databases we
>>copy an MDE file from the network onto a user's local HD. The
>>user can usually access the MDE file with no trouble but it is 'read only'
>>mode on the user's computer.
>
> Where do you copy the file to? Program files? Don't as that is read
> only to regular users.
>
> Instead use %app data%\<your app name> which is usually C:\Documents
> and Settings\ttoews\Application Data\<your app name> in Windows XP.
> Different in Windows Vista.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

It copies from the share to local as:
mapped_drive:\app copies to local_drive:\app

"Tony Toews [MVP]" wrote:

> BrianMultiLanguage <BrianMultiLanguage@discussions.microsoft.com>
> wrote:
>
> >I am having an issue with MS Access. Here is the situation: We
> >keep all of our backend and front end mdb files on a network
> >share that only myself and a few other database designers have
> >permissions beyond read and file scan. To deploy databases we
> >copy an MDE file from the network onto a user's local HD. The
> >user can usually access the MDE file with no trouble but it is 'read only'
> >mode on the user's computer.
>
> Where do you copy the file to? Program files? Don't as that is read
> only to regular users.
>
> Instead use %app data%\<your app name> which is usually C:\Documents
> and Settings\ttoews\Application Data\<your app name> in Windows XP.
> Different in Windows Vista.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
>

BrianMultiLanguage <BrianMultiLanguage@discussions.microsoft.com>
wrote:

>It copies from the share to local as:
>mapped_drive:\app copies to local_drive:\app

So what kind of permissions does the user have to local_drive:\app?
Is that your own folder or do you mean C:\Program Files?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

"david" <david@nospam.au> wrote in
news:OQQQaikEJHA.612@TK2MSFTNGP06.phx.gbl:

> Or, if you are using roaming profiles and don't want the MDE to
> roam, to "Local AppData", which is usually
>
> C:\Documents and Settings\..user name..\Local Settings\Application
> Data\
>
> in Windows XP.
>

Good catch -- I never knew about that one.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/