James W. wrote:
If the dbf file is open in excel I am assuming that it would be the
same as reading and writing data to a worksheet, correct me if I am
wrong. Is it possible to write the data to a dbf file that isnt open
in excel? If so please point me in the right direction.

Reasoning behind this:
Project Shop Floor Control
I have created multiple forms that are used on our production
floor, using Excel as the host application. I would like to store
this data in a more secure location so that data cannot be
manipulated in any way except through the forms I have created. I
felt that access would be perfect for this but I doubt I could get
them to buy 15 seats of access. I am mearly looking at alternative
means to store this data rather than
just in a worksheet. Your insight is greatly appreciated.


Use Access. You only need a single licence for the person who will create
and administer the database. All of the other seats can connect into the
Access db via Excel, ADO and VBA. ADO (via the MIcrosoft Data Access
Components - MDAC) can be installed freely on all the other machines in the
group (in fact it's probably already there).

--
Rob

http://www.asta51.dsl.pipex.com/webcam/