>What is the proper way to tell if someone else is already using a table? See if you can do an flock()? A "use filename exclusive" and check for an error?
>
>Thanks

The only way to reliably get a table EXCLUSIVE (note this is different than FLOCK()) is to try to USE table EXCLUSIVE and trap the error in an ON ERROR routine if someone else has the table open.