Access, shares, med, read only.

[BrianMultiLanguage]

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.

 

[BrianMultiLanguage]

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

 

[Tony Toews [MVP]]

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/

 

[david]

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.

 

[BrianMultiLanguage]

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

 

[Tony Toews [MVP]]

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 W. Fenton]

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]

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?

By default, the root of C:\ (or any system drive) is going to be
read-only, just like the programs folder.

User-writable data needs to be stored in the user's profile.

This has been so since the release of Windows 2000.

 

[Tony Toews [MVP]]

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.

Interesting. Now how does that work on Terminal Server systems?

I ask because we want the user to copy of the FE to a system that's
local to the LAN on which the TS or file server system resides. And
not on the home PC which could be thousands of miles away.

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/

 

[Tony Toews [MVP]]

By default,

Key words there. <smile> I'm attempting to determine exactly what
the original poster means.

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]

That folder doesn't roam because in the default group policy there is a
specific exclusion for folders with the name 'local settings'. I haven't
looked
at that for years, so I'm only guessing it hasn't changed. It does make me
wonder what the group policy is for different languages - the one I remember
was not using a language-neutral guid for the folder. You can if you want
make a different group policy for roaming profiles instead of using the
default.
And you can put TS clients into a different group.

It used to irritate me that Firefox wasn't smart enough to default to the
correct location for it's cache: a large web cache in your roaming profile
really slows down your login-logout. I think Firefox might be fixed now
but I still like to remind people that a mistake here really hurts the
corporate
user.

(david)

 

[David W. Fenton]

It used to irritate me that Firefox wasn't smart enough to default
to the correct location for it's cache: a large web cache in your
roaming profile really slows down your login-logout. I think
Firefox might be fixed now but I still like to remind people that
a mistake here really hurts the corporate
user.

Firefox's cache location is easily changed. Add this configuration
parameter and set it to the location you want the cache folder to be
created in (the folder already has to exist in order for this to
work):

browser.cache.disk.parent_directory

 

[david]

I'm aware of that: it's why I'm not sure if the default install has
been correctly fixed.

(david)

 

[Tony Toews [MVP]]

That folder doesn't roam because in the default group policy there is a
specific exclusion for folders with the name 'local settings'. I haven't
looked
at that for years, so I'm only guessing it hasn't changed. It does make me
wonder what the group policy is for different languages - the one I remember
was not using a language-neutral guid for the folder. You can if you want
make a different group policy for roaming profiles instead of using the
default.
And you can put TS clients into a different group.

I would only get that information from the API calls so that should be
language neutral.

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 W. Fenton]

I'm aware of that: it's why I'm not sure if the default install
has been correctly fixed.

That's an actual bug, and you should check Bugzilla to see if it's
been filed, and, if not, file it yourself.