BJ murray database disappears to users

[alarmmd]

I have a netware 5.1 system with BJ Murrary Software and every couple of days the database locks up and when users try to re enter the program it comes up with no such file. Then i do a restore from a backup from the day before and they are OK for a while.The database has had no service since 2000. I do not know which dos command to use to reindex or repair the database .
Thanks for any and all help.

 

[mirtheil]

Before you "reindex" or "repair" the database, you need to identify the problem so that it doesn't happen.
What's the Btrieve error code that's being returned? It would be a number. Also, have you tried just restarting the server? Does that help?
Do you have any other Btrieve tools that you could test with? For example, when the program returns the "no such file" error, use the Btrieve Function Executor or BUTIL (DOS program) to open the data file. Does it give an error? If so, what's the error?


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com