I apologize for the newbie questions in advance:
I have an Excel spreadsheet on my hard drive shared to the network:
\\TOOLSApps\c_drive\SalesOrders\sornew.xls
This is an "open sales order report" for our company. I won't go into details as to why it's Excel, how it's updated, etc. Suffice to say it is what it is.
I have multiple databases on the network and on local hard drives scattered throughout manufacturing. The all have 1 thing in common...the open sales orders. It is used as the basis to print reports and labels from a variety of manufacturing stations (around 25 stations). It's also used in bill of material inquiries, inventory inquiries, routing inquiries, etc. The databases are in formats of Access2000, 2003 and 2007and upgrading all to a common format is not feasible at this time. All stations are XP Pro.
No station on the floor has any security access for writing to the network. All are read only. All they do is open a database, look at the form, pick a line item, and click a button. Then a form or report will open or print as the command button dictates.
The problem is....If station 1 is viewing and printing an open order report, station 2 can't open their form to print a label, or station 3 can't open a form to view a bill of material, etc. until everyone else exits. It just says "can't open file because it's already opened........." Any station can do anything but only 1 at a time.
How do I share this spreadsheet to the multiple database stations so it can be opened by more than one station at a time in read only mode?
I have an Excel spreadsheet on my hard drive shared to the network:
\\TOOLSApps\c_drive\SalesOrders\sornew.xls
This is an "open sales order report" for our company. I won't go into details as to why it's Excel, how it's updated, etc. Suffice to say it is what it is.
I have multiple databases on the network and on local hard drives scattered throughout manufacturing. The all have 1 thing in common...the open sales orders. It is used as the basis to print reports and labels from a variety of manufacturing stations (around 25 stations). It's also used in bill of material inquiries, inventory inquiries, routing inquiries, etc. The databases are in formats of Access2000, 2003 and 2007and upgrading all to a common format is not feasible at this time. All stations are XP Pro.
No station on the floor has any security access for writing to the network. All are read only. All they do is open a database, look at the form, pick a line item, and click a button. Then a form or report will open or print as the command button dictates.
The problem is....If station 1 is viewing and printing an open order report, station 2 can't open their form to print a label, or station 3 can't open a form to view a bill of material, etc. until everyone else exits. It just says "can't open file because it's already opened........." Any station can do anything but only 1 at a time.
How do I share this spreadsheet to the multiple database stations so it can be opened by more than one station at a time in read only mode?
