Hi, I have a VFP6 (SP5) application that opens a local VFP database that purely consists of remote views. As we all know, this database can become corrupted by PC crashes, [Crtl][Alt][Del] etc. Questions:

1) Is there any way of opening the database and trapping the fact that it is corrupted so that the application can automatically recreate the remote views?

2) Is there any method of changing the way remote views are recreated? Currently when recreating remote views, each view seems to be generating an SQL command of "SELECT * FROM table" which on large tables and on a WAN can take a long time (several minutes).

Thanks in advance