>>>>I'm having trouble with an SQL statement that creates a temp dbf. Its a standard statement Select * From...
>>>>Sometimes the created file ise set to exclusive use, and sometimes its not. This occurs even if I set exclusive off and then close and reopen the temp file. Any Clues?

cursors created by SELECT SQL are read-only - u can
make them r/w by USEing AGAIN (see tip in VFUG tips section)
if you need them shared over the network you should make sure the temp/work files are created in a network shared directory

Arnon