Go to the server and see who has the table open - it is locked by some user somewhere.
Has anything changed on the setup of the server? Could be a virus scanner as well.
>I have a working database that has been operational -flawlessly - for about 10 years in a 24/7 operation until last night.
>
>One of the tables in the database is now erroring with the following message (which I didn't program into the table.) "Record not available ... please wait" The message appears in a wait window and locks the program. This happens on all machines. Each machine has their own .exe.
>
>I tried to go in through the 'backdoor' into the raw table through VFP and got the same message and it locked VFP.
>
>I'm using VFP 8 with the tables located on a server.
>
>All other tables in the project are ok.
>
>Any help would be appreciated as to cause and repairability. Thanks.
>Linda
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown