Only with the network access permissions. There is no other way to tell
Excel that the file that is about to be overwritten should not be
overwritten.

Edmund

"CCrew2000" wrote in message
...
BUt is there a way to prevent a file from being over wrtten without using
Access?

"Edmund" wrote:


You can link the Excel file into Access as a linked table. That way the
updates are actually saved to the Excel file. You get to control access
to
the data through Access AND keep the data in an Excell file.

Edmund

"CCrew2000" wrote in message
...
The file is designed for another (1) user to update a bunch of data in
the
file. Once they are done, they save it and then I use it for other
functions. We've thought about using Access, but its too late in the
game
to
use at this point in time.

I'm looking to see if there is a way to prevent them from oversaving a
file.

"Edmund" wrote:

What sort of data is in the file? I ask becuase it sounds like this
may
be
better suited to a database (eg. MS Access). If multiple users need
to
access/update the data then perhaps it is not a good idea to use a
system
that is not designed for such. A database is designed to do just
that.
Can
you put it into a database?

Oh, I just though of something. Did you know that you can link the
Excel
file as a table in an Access database. I think each sheet can be
linked
as
a table. Then you could use the Form Wizzard to create forms to
access
the
linked tables (that are really the excel pages). That way if you
really
needed the data in Excel, say, for some macro or charting, then it can
stay
in Excel; while the access is controlled by Access.

Edmund


"CCrew2000" wrote in message
...
Problem is that I want them to be able to open the file, make
changes
and
save it at that time. If they "save as" the file to another
location,
then
there are now two versions of the file. This could cause issues
down
the
road.

I'd like to be able to protect the file to prevent it from being
saved
over.
Have it ask for a password or something along those lines. I
already
have
a
password in order to open the file.

"Edmund" wrote:


Set the file as read-only. Or you can get the System Administrator
to
make
that network folder read-only, since savy users will simply set the
file
to
read-write and then save over it (if any of your users are that
savy).

"CCrew2000" wrote in message
...
Is there a way to prevent someone from saving over a specific
file?

I've created a file on a network drive for some users. Some of
the
users
complain about the time it takes to open the excel file. What
they've
done
is save the file to their C:\ once the file is open. Make their
changes
and
then "save-as" back to the network drive (thus overwriting) the
original
file.

How can I prevent them from saving over my file with their "new"
file?