Mike Try reloading the database then run autochk again. I have an MS SQL Server database table sattached and I don't receive any errors.
Buddy -----Original Message----- From: Ramsour Mike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 8:05 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Errors during AUTOCHK Good morning: I have been encountering the following errors during an AUTOCHK <database> FULL. This is the code that I run to check the database: DISCONNECT -- SET MULTI OFF -- CLEAR ALL VAR now -- SET ERROR VAR verrtrap -- OUTPUT d:\autoload.$$$ -- AUTOCHK MAINDATA FULL -- SET VAR vchk_result = .verrtrap -- OUTPUT SCREEN -- CLS -- IF vchk_result <> 0 THEN -- CLS -- OUTPUT d:\bad_load.txt -- WRITE 'Errors encountered during pre-check -- aborting' -- OUTPUT SCREEN -- GOTO endline -- ENDIF The results that I get in the autoload.$$$ file are: Successfully opened file #1: D:\rbase\data\MAINDATA.RB1 Database lock acquired. -ERROR- Error reading the table list. (1220) Unable to acquire all table locks. Errors may occur due to database activity. Successfully opened file #2: D:\rbase\data\MAINDATA.RB2 Successfully opened file #3: D:\rbase\data\MAINDATA.RB3 -ERROR- Unable to open database file number 4. (1209) Please provide some insight into what would cause these errors. I have three SQL Server tables attached over an NT network using ODBC. Could there be something related to this that would cause some errors? Any input is always greatly appreciated. Thanks Mike Ramsour Voice: 740-829-4340
