Re: need help trouble shooting

[David M. Blocker]

Tricia   Some basics:   1.  Get all users out, disconnect and AUTOCHK dbname FULL to be sure there is no corruption. 2.  Check indexes.  Best way, after backing up, is a PACK KEYS command.  This rebuilds them all. 3.  If problem persists, copy the database to another machine's hard drive.  Try the same commands there to see if the problems you are experiencing go away. If they do, you know the problem lies in somewhere in the network.   David Blocker   ----- Original Message ----- From: Tricia PORTER To: < Sent: Wednesday, September 11, 2002 12:16 PM Subject: need help trouble shooting rbase 6.5++ windows (on a network)   I'm still trying to trouble shoot my database problems and I noticed when one of my procedures gets to the command line "rename table tblname to tablename2" I get the following error:   "RBG65.exe has generated errors and will be closed by windows.  you will need to restart the program.  An error log is being created."   I went to my tables and tried to rename a "test" table that I created and I got the error again, so for some reason I can not rename any of my tables.   This may be an unrelated problem, but when I gateway data into my tables I get the following message:   "There is insufficient disk space on either the target drive or the temporary file drive.  The operation may fail.  Do you wish to continue?   I do continue, and my data seems to gateway fine.   Can anyone offer some direction on where to start trouble shooting for this problem?  My two main problems are, I keep getting the above error message when I run certain procedures, and my database is running very slow.  Even when I move the scroll bar in a table it moves very slowly.  I did clear all of my variables and that did not seem to make a difference.  Another suggestion I got was to check my indexes and I'm going to work on that now.   All help is very much appreciated.  Tricia