|I'm having trouble getting an Access plugin working for all users. The setup application installs/registers the dll and associated tlb file absolutely fine (installed for all users) and my VBA code (below) also works successfully when logged in as an administrator, but attempting to use it under a non-privileged user account fails here:
Private Sub Form_Load()
.Connect = True
The returned error is: This add-in is installed for all users on this computer and can only be connected or disconnected by an administrator.
Is there any way to prevent this?
Some additional information:
- The dll/tbl and setup application are all created in C# (.net 3.5)
- The target machine is virtualised, so any user could potentially log into it (thus installing the plugin for the active user isn't an option... though if there's a way to silently install the file in a user login script that might work?)
Thanks in advance... though I'm more hopeful than expectant!