Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading From & Writing To an Excel Database
Our company has an Excel Database ("Database File") on the server. There is
a second Excel file ("User File") on the server that both accesses and updates the Database File. There are 3 people on the network with more to come. I have two questions regarding this: 1) The User File needs to be able to support "Multiple, Simultaneous Users". What is the best way to accomplish this with out using Microsoft's Shared Workbook as I have heard there is a loss of functionality. One option I thought of is when Person "A" opens the User File it automatically saves it as a new file so that Person "B" could open the User File with out it being 'read only'. Would this work? Is there a better way? 2) It seems to me that the Database File would have to be closed for multiple users to access it as the same time. What is the best way to Read from & Write to the Closed Database File? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reading and writing to ini files in Excel 2007 | Excel Programming | |||
Need sample for reading value from and writing value to cell E53 from outside Excel | Excel Discussion (Misc queries) | |||
Need sample for reading value from and writing value to cell E53 from outside Excel | Excel Programming | |||
question about Excel file writing and reading | Excel Programming | |||
Reading data from an excel sheet and writing to another | Excel Programming |