Tricia -
Have you tried an UNLOAD ALL to do a plain vanilla total rebuild of
the database? This sounds like database corruption. I've never had a
problem with RENAME TableName TO NewTableName.
Bernie
---------------------------------------
At 05:28 PM 9/20/2002 -0600, you wrote:
>r:base 6.5++ windows (on a network)
>
>Thank you everyone for offering advise on trouble shooting my database.
>I'm learning a lot, and just so razzak knows, I'm having fun.
>
>I have pin pointed by error message problem.
>I can't RENAME my tables. Everytime I run a program with the RENAME
>table command I get the following error message.
>
>"RBG65.exe has generated errors and will be closed by windows...."
>
>I can RENAME my forms and reports just fine.
>I have taken all of the advise offered so far. I have cleared all
>variables, I've done a full pack, checked my indexes, and tried
>re-installing the R:base program files incase the RBG65.exe is corrupt.
>I have copied my database to a PC that is not on the network and my
>database does run A LOT faster, but I still get the error messages when
>trying to RENAME a table. I've tried deleting my tables and recreating
>them and that doesn't work either.
>
>I have recreated a portian of my database as a new database with new
>tables ext. and the new database runs fine.
>
>Does anyone have any more suggestions? Tricia
>Content-Type: text/html; charset=ISO-8859-1
>Content-Transfer-Encoding: 8bit
>Content-Description: HTML
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
><HTML><HEAD>
><META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
><META content="MSHTML 5.00.2920.0" name=GENERATOR></HEAD>
><BODY style="FONT: 8pt Tahoma; MARGIN-LEFT: 2px; MARGIN-TOP: 2px"><FONT size=2>
><DIV><FONT size=2>r:base 6.5++ windows (on a network)</FONT></DIV>
><DIV> </DIV>
><DIV><FONT size=2>Thank you everyone for offering advise on trouble
shooting my
>database. I'm learning a lot, and just so razzak knows, I'm having
>fun.</FONT></DIV>
><DIV> </DIV>
><DIV><FONT size=2>I have pin pointed by error message problem.
></FONT></DIV>
><DIV><FONT size=2>I can't RENAME my tables. Everytime I run a program
with
>the RENAME table command I get the following error message.</FONT></DIV>
><DIV> </DIV>
><DIV><FONT size=2>"RBG65.exe has generated errors and will be closed by
>windows...."</FONT></DIV>
><DIV> </DIV>
><DIV><FONT size=2>I can RENAME my forms and reports just fine.</FONT></DIV>
><DIV><FONT size=2>I have taken all of the advise offered so far. I have
>cleared all variables, I've done a full pack, checked my indexes, and tried
>re-installing the R:base program files incase the RBG65.exe is
>corrupt.</FONT></DIV>
><DIV><FONT size=2>I have copied my database to a PC that is not on the network
>and my database does run <STRONG>A LOT </STRONG>faster, but I still get the
>error messages when trying to RENAME a table. I've tried deleting my
>tables and recreating them and that doesn't work either.</FONT></DIV>
><DIV> </DIV>
><DIV><FONT size=2>I have recreated a portian of my database as a new database
>with new tables ext. and the new database runs fine.</FONT></DIV>
><DIV> </DIV>
><DIV><FONT size=2>Does anyone have any more suggestions?
>Tricia</FONT></DIV></FONT></BODY></HTML>
>
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
