Open tables

[AdamVerellen]

I have an application that needs to open a table that could be open by another application(which may hold it exclusively). How would I got about finding out if its in use? I tried an error utility type workaround by retrying unitl its released. Maybe there is a better way.

I found out the hard way used() doesn't work.

Adam

 

[danceman]

temp = fopen('myfile.dbf')
if temp < 1
file already in use
else
fclose(temp)
endif Attitude is Everything

 

[AdamVerellen]

Thanks

 

[Mike Gagnon]

AdamVerellen

Just trap the error:

ONERROR do myOpenTableerror

use myOtherTable.dbf shared && This might cause an error

PROCEDURE myOpenTableError
messagebox("Table is used my another user...Come back later.")
ENDPROC

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first