>Can anyone give any insight on how to avoid this error or setup a retry?
>
>I have a database access remote SQL data for a web application.
>
>My code simply is "Use MYVIEW Again"
>
>I get the error about every 50th time the code is run.
>
>All / Any help is appreciated.
>
Foxpro locks view definition in DBC shortly during openning. There're a few workarounds:
- Use VFP7 new SYSTEM clause in SET REPROCESS command to increase time or number of attempts.
- Provide separate DBC with views for each user. I'm not sure if you can do it for web access.
- Mark DBC with views as read only. It was reported that it works but you should test for yourself for any side effects.
--sb--