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?