"There was an error executing the command."

[Nidhal]

I have a database that is being used by multiple users. Each user has an MDE file on their PC and the data is stored/referenced in a separate mdb on a network shared drive. When someone is using the program concurrently and a second user tries to open forms, etc. I always receive the following error message:

"There was an error executing the command."

I have set the Default Open Mode to "Shared" and the
Default Record Locking mode to "No Lock"

I don't understand why I'm receiving this error message if someone else is already in a shared database.

Many thanks to anyone who can answer this

-Nidhal

 

[hneal98]

What kind of code do you have executing when the form opens?

 

[willir]

Perhaps you can try recreating the MDE file...
- Test multiple connections with the MDB front end
- Re-test multiple connections from the above MDB after it has been converted to an MDE

Also, with an MDE file, it pays to have good error trapping so the trapped errors can be more descriptive, and perhaps with some built in logic to allow the end user to continue one to other stuff.

In addition, it usually pays to capture errors in a log file for tracking. The log file may be captured as an external text file (probably better since you may need to trouble shoot why you can not access a database), or within the database itself.

And, it can take one user to lock up a database and spoil the fun for all. Look at the LDB file to see if you can determine if this is the case.