If nothing else, you could set multi off while doing your download etc...
Ben Petersen On 25 Nov 2001, at 23:24, CASTANARO wrote: > Hello all, > > I have an R:base command file that runs automatically every hour (many > thanks to Ian Stone for his utility). This command file downloads data via > ODBC to a table and then performs some R:Base wizardry for about 5 minutes. > The problem is - i have users who access this table to print a report, > sometimes unknowingly while this command file is running. Obvoiusly, when > the command file is running the data is changing frequently. i would like > to prohibit access to this table while the command file is running. tried > "SET LOCK tablename ON" but other users still can print report. I guess > this just means it locks out writes to the table. Is there a command I'm > missing to temporarily suspend read of the table? There are no passwords > on this database. > > Thanks >
