473,289 Members | 1,929 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,289 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 1982

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: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
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: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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...

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.