View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default Using shared "Read Only" program file

EXECUTIVE OVERVIEW: Does anyone know of any issues that could arise from
allowing multiple users to concurrently use a program file set to
automatically open "READ ONLY"?

I have a file that many users have a copy of. It contains several VBA
programs. This program file runs hidden and all programs are executed from
toolbar controls. The program file itself is static, the programs only
manipulate the file or files the users have active. The program verifies that
the correct files are open before executing any functions.

Each year a few changes are made and in the past, I have distributed this
program by e-mailing it to all users who then save their own copy locally,
with instructions to over-write their old version. This method has worked
fine for the past three years.

Here is my question. Rather than sending out a new version once a year to
each individual user, would there be any draw back or problems with changing
the program file property to always open "READ ONLY" so that the file could
be used concurrently by all the users. I could place ONE copy the file on the
network (accessible to all users). The program auto-installs a toolbar when
opened and then, as previously stated, all functions are performed only on
the user's active files.

If you have any ideas, please post back. Thanks much in advance.