Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Record not available!!!!
- Thread starter Vivianez
- Start date
- Thread starter
- #3
Could it be the foxuser.dbf or foxhelp.dbf?
The application does not even shows the menu options...and I´m not using any dbf.
The message "Record not available" is in the same line as the INS and NUM.
It happened 2 times this month and the application is running since 1999.
The application does not even shows the menu options...and I´m not using any dbf.
The message "Record not available" is in the same line as the INS and NUM.
It happened 2 times this month and the application is running since 1999.
TheRambler
Programmer
See Microsoft Knowledge Base Article - 93348 for some explanation, but it doesn't help much.
I guess you are right about the foxuser.dbf (and foxuser.fpt) files. Somewhere I read Fox locks individual records in a table, but uses file locking for memo files and indexes. So, if you update a record in foxuser.dbf and the system hangs up, then foxuser.fpt is not updated and you get the message described. Maybe somebody else can explain better this behaviour.
If this is the case, I would check to see if every user has its own foxuser.* files.
I guess you are right about the foxuser.dbf (and foxuser.fpt) files. Somewhere I read Fox locks individual records in a table, but uses file locking for memo files and indexes. So, if you update a record in foxuser.dbf and the system hangs up, then foxuser.fpt is not updated and you get the message described. Maybe somebody else can explain better this behaviour.
If this is the case, I would check to see if every user has its own foxuser.* files.
- Status
Similar threads
