I have a really confounding problem. Situation: Small non-profit organization with 7 workstations, mostly Dell Pentium 4s. Office network uses a Buffalo server and router. I don't know for sure, but assume the network is a simple 10Base-T. The organization runs on the MS Access databases I've designed, one of which is a reservation system. The major tables for that system are the Signups table, where the information for each reservation is collected and the EventSched, which simply contains data for all the events for the year, with event type, date, departure and return time, location, program type, etc. The tables contain a lot of links to auxiliary tables, per the attachment. The database is a client/server design: Forms on the workstations, tables on the Buffalo.
Each year, I go in and set up the reservation tables for the next year, in this case 2010. I did that yesterday. I first copied the database containing the 2009 tables to a file with the name "10 PublicSailTbls.mdb". After deleting all the records in the Signups, EventSched, Manifest, and HowPaid tables to make them ready for next year's entries, on the workstation on which I was doing this, I also copied the 2009 Forms (client) side of the split database, changed the name to "2010 PublicSailForms.mdb" and changed the links to the 2010 tables file on the Buffalo. This is the same process I have used for the last 9 years.
Problem is, the 2010 Signups form will open on only two of the workstations. On the others, the system goes into "indefinite busy" (hourglass). Task Manager indicates Access and everything else is "not responding", but attempts to "end task" fail. Only way to restore the system is to select "Restart". Because it worked on two workstations, we thought perhaps the network was not working properly, so "regenned" it (shut all computers down, shut the Buffalo and router down, waited one minute, then brought the network back up). Didn't change anything; system still works on two of the workstations, but not on the others.
Anybody have a clue as to what's going on/where I should look for the cause of this odd problem?
Each year, I go in and set up the reservation tables for the next year, in this case 2010. I did that yesterday. I first copied the database containing the 2009 tables to a file with the name "10 PublicSailTbls.mdb". After deleting all the records in the Signups, EventSched, Manifest, and HowPaid tables to make them ready for next year's entries, on the workstation on which I was doing this, I also copied the 2009 Forms (client) side of the split database, changed the name to "2010 PublicSailForms.mdb" and changed the links to the 2010 tables file on the Buffalo. This is the same process I have used for the last 9 years.
Problem is, the 2010 Signups form will open on only two of the workstations. On the others, the system goes into "indefinite busy" (hourglass). Task Manager indicates Access and everything else is "not responding", but attempts to "end task" fail. Only way to restore the system is to select "Restart". Because it worked on two workstations, we thought perhaps the network was not working properly, so "regenned" it (shut all computers down, shut the Buffalo and router down, waited one minute, then brought the network back up). Didn't change anything; system still works on two of the workstations, but not on the others.
Anybody have a clue as to what's going on/where I should look for the cause of this odd problem?