The AcroRd32.dll issue is probably due to VBA reference to Adobe Acrobat library. I removed code that manipulated PDF files but forgot to remove reference. It is not critical, just annoying.
The VBScript file was only included for info. The db has self-copy code that I posted. The VBScript could still copy the file but is not required. This all assumes your computers will allow programmatic copy of files. Here is code when it called the VBScript.
Code:
'Because administrator opens the master development copy, only run this for non-administrator users
'Check for updates to the program on start up
'If values don't match then there is a later version
Set Shell = CreateObject("WScript.Shell")
Shell.Run CurrentProject.Path & "\Update.vbs"
Dim WAIT As Double
WAIT = Timer
While Timer < WAIT + 3
DoEvents
Wend
Set Shell = Nothing
Application.Quit
This db was designed to have backend on a LAN file server (is that what you mean by 'shared drive'?) and frontend copies on each user computer. I use code in Utilities module to set table links with UNC path.
Go to module Misc and set global variable gstrBasePath. Suppose I should have set up a table to hold this value and load variable from table. Hindsight is wonderful. My folder setup has backend in its own folder, master development copy of db in folder that only I have permission to, and downloadable copy of frontend for users in another folder. gstrBasePath is for path to parent folder that holds those 3 sibling folders. Then search for that variable in code and modify remainder of path as needed. It is used 4 times but the only critical one is in Login form.
As developer, I normally open db with shift key bypass then manually open Login form. Login process relies on LAN username. After record created in Users table, make sure you are an 'admin' user. When all works, Menu should open after Login.
I replaced file at Box.com.