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
