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.