>Hi all!
>
>I am using sql6.5 sp4 for my database and using VFP for my front end.
>When we upgraded from VFP3 to VFP5, we started getting this message:
>
>"Error (###). The database is currently in use by someone else."
>
>We made sure that all the databases were not locked into single user mode, we also made sure all connections and settings were set to Shared.
>
>Has anybody experienced this problem and know how to fix it or maybe even just duplicate it. It is a random event; with over 500 hits a day, it may happen once a week.
>
>Please help, it will be greatly appreciated.
Do you mean
'Error 1709 the database
object is being used by someone else' ?
This error stems from 2 users attempting to open a view at the exact same time. I can't figure out for the life of me why opening a view causes a lock on the dbc record, but this is what happens. The recommended fix is to put a special clause in your ON ERROR routine that issues a RETRY in the case of this error.
Erik Moore
Clientelligence