I have an Access97 database running on a Windows NT 4.0 SP5. The computer is connected to a Novell network. I don't have the Novell client installed on the pc, I am just using the Novell Netware Client that comes with WinNT.
The program looks for a file on the Novell server. If it sees the text file, it imports it and then stores the data in a linked table. The DATA database is also stored on the Novell server, and this program has about 6 links to the DATA database. If the program doesn't see a text file, it will then loop and check again (about every minute it checks). After it checks, it updates the time on the form, so we know when it last checked to see if the text files exists.
Problem: The program can run fine for 3-4 days, then all of a sudden not work. The program does import the file and the form that has the time on it updates, but the program doesn't do anything with the data from the text file. It will take the text file, go through the code like it is going to work, and then deletes it(it is programmed to do that). If I break out of the program and check the tables, I get the following message, "Invalid Argument." It also gives me a "Disk or Network Error. I can't do anything and have to ctrl-alt-break and end task. After seeing the Disk or Network error, I checked to see if I am still logged in, and I am. I can view all the files on the Novell server.
If I close the program and reopen it, it will work fine. This past weekend when I reopend it, it said that the database had to be repaired. What would cause this??
Does anyone know what is causing my problem? The database is restarted every weekday and is also compacted. It just doesn't happen on the weekends, it happens any time of the week.
Thanks.
Nick
The program looks for a file on the Novell server. If it sees the text file, it imports it and then stores the data in a linked table. The DATA database is also stored on the Novell server, and this program has about 6 links to the DATA database. If the program doesn't see a text file, it will then loop and check again (about every minute it checks). After it checks, it updates the time on the form, so we know when it last checked to see if the text files exists.
Problem: The program can run fine for 3-4 days, then all of a sudden not work. The program does import the file and the form that has the time on it updates, but the program doesn't do anything with the data from the text file. It will take the text file, go through the code like it is going to work, and then deletes it(it is programmed to do that). If I break out of the program and check the tables, I get the following message, "Invalid Argument." It also gives me a "Disk or Network Error. I can't do anything and have to ctrl-alt-break and end task. After seeing the Disk or Network error, I checked to see if I am still logged in, and I am. I can view all the files on the Novell server.
If I close the program and reopen it, it will work fine. This past weekend when I reopend it, it said that the database had to be repaired. What would cause this??
Does anyone know what is causing my problem? The database is restarted every weekday and is also compacted. It just doesn't happen on the weekends, it happens any time of the week.
Thanks.
Nick