>>Stephen,
>>
>>First the event order thing. OpenFiles does fire before the BeforeOpenTables. This is because the latter fires before the tables are opened, adn the fomrer is the event that opens the tables, so that the OpenTables fires, it then starts to open tables, but before the tables are openned the BeforeOpenTables fires. If the OpenTables doesn't fire, then the BeforeOpenTables will not fire.
>>
>>The simplest way to handle the specific problem that you are facing is to use the Error event of the form. In there trap the File Is In Use by Another error and give your message and call the form's release to shut it down.
>
>Jim,
>
>I was trying to experiment with the Error event of the DE which also trapped the error properly, but I couldn't seem to get the form to be right. I'll try the error event of the form as you suggested. Thanks.
>
>Steve
Jim,
The DE insists on blowing up well before it gets to the form's .Error event so it seem I must trap it in the DE's .Error event. This is not a smooth mechanism for detecting a table in use by someone else.
Steve
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement