473,327 Members | 2,025 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Access 2003 Add-In Rights?

Greetings,

I'm having problems with the use of an Access 2003 Add-In on Windows
XP Pro. Administrative-level users have no problems running the
Add-In, but those users with restricted rights on the same computer
can't use the Add-In.

We are cloning a setup to copy to multiple identical machines, and I
just want to install the Add-In to be available to All Users without
fiddling with rights and manually installing for each person (and
making entries in their profile).

I've installed my Add-In for "All Users" on the WinXP Pro Office 2003
clone by doing the following:

1. The Add-In .mda file is copied to the folder
"C:\Documents and Settings\All Users\Application
Data\Microsoft\AddIns"

2. I run a registry file (.reg) that creates the Access v. 11.0
entries pointing to the file in the folder in (1) and telling it how
to start--the typical Add-In registry keys. I have lots of experience
with this--and simply create the entries that a manual installation
would do, but instead pointing to the All Users location for the .mda
file.

3. The security on the All Users profile Add-In folder/files (in (1)
above) is set for Everyone to have Full rights--so that the Add-In can
be modified during use--as is necessary.

4. Access 'Macro Security' is set to Low so the code can run unimpeded
(I don't know if this is truly necessary but eliminates one possible
source of my problem).

This same approach has been used in recent months for new machines
with Access 2002 (XP) with Win XP Pro, and regardless of whether they
are administrators or restricted-rights-users on those machines, the
Add-In runs without any problems. So I know the approach works. This
problem only occurs on the new Access 2003 machines.

Here's the situation for three scenarios on identical machines:

* Users who have full administrative rights to their machines have no
problems, i.e., the Add-In works as intended from the All Users
profile AddIn folder as installed above, so I know there are no code
problems or registry setting problems with the .mda file.

* Users who *had* rights when the add-in was installed manually to
their own profile have no problems, either, even when their
administrative rights were later removed. These users retain full
rights to their own profiles, so they are similar in many ways to
administrative users.

* Users with restricted rights who are loading the add-in as I
intended, through the All Users profile, can bring it up from the
add-in menu, but that's it. They cannot write to the Add-In file in
the All Users profile so are unable to use the Add-In (using it
changes data within the .mda file).

The most telling symptom: When the Add-In is selected its splash
screen pops up, but the user can't check the box that says not to show
the splash screen again. Checking/unchecking the box simply toggles a
Boolean field in a one-record administrative table that is the data
source for the splash form within the add-in. So the user can't write
even though they have Full rights to the AddIn folder/files.
---------------

I'm stumped. Your help would be greatly appreciated.

Thanks in advance, Access gurus.

-=Steve
www.CleanDataSystems.com
Nov 12 '05 #1
0 1983

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: mal hit | last post by:
We developed an ASP.NET application on Windows 2000/SQL Server 2000/IIS 5.0. Recently, we moved the SQL Server 2000 database to Windows 2003. Now, we are unable to connect to the database (on...
0
by: ImraneA | last post by:
Hi there I had pleasure of upsizing Access v97 db to Access v2K/SQL 2K. Wish to provide some knowledge gained back to community - hopefully help others. 1.Question how do you test stored...
4
by: martin | last post by:
Can anyone please help. I have a main membership form/table that has a subform with function table linked. This is obviously a fixed solution but I would like to make it more dynamic with a combo...
11
by: Danny J. Lesandrini | last post by:
Has anyone else noticed this? I searched group archives and found nothing, but it's really starting to irritate me big time. Here's the steps to reproduce the problem: Copy something to the...
1
by: russ | last post by:
I installed VS.NET, Office Access 2003 Developer Extensions, and Access 2003 Developer Extensions, and I still can't find where the Access 2003 runtime install file is at. Am I missing something?
2
by: ad | last post by:
I have a virtual which is a web service. When I use the IP to get the web service, it return a access denied message: http://xxx.xxx.xxx.xxx/HealthService/Service.asmx but if I use local host,...
5
by: chevyhound | last post by:
Has anyone had any issues with Access 2003 with windows Vista? Everytime i open Access i get windows installer running. When i try to create a new report, I get "Installing Microsoft Access...
3
by: gazsharpe101 | last post by:
Hi everyone, I am doing some work on my company's database. It is a MS Access 2003 front-end with an SQL back-end. Recently, I have asked the database administrator to add some new fields to...
6
by: jkmobil | last post by:
Been using Access 97 for years. I use a statistics add-on (Total Access Statistics) which is kind of expensive and I haven't found anything to be gained by upgrading. But I'm now told I probably...
3
by: Bruce | last post by:
I have a number of Access 2000 format databases on a Windows 2003 server. For some reason I can no longer compact these databases directly on the server using Access 2003. Access 2000 seems to...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.