asked on

MDB's with Visual Basic

I am running an app over a 2 computer network; when the client computer runs the app over a mapped drive I get the following:
"Run-time error '3051'; The microsoft Jet database engine cannot open the file (drive\folder\mdb). It is already opened exclusively by another user, or you need permission to view its data."
The app is not running, the mdb is not open, and there are no permissions on the mdb. Help?

mukvij

I did same thing with my setup and it worked for me. This error generally comes when MDB file if open in design mode. double check that. Also check permissions on disk share for your login. Does that help.

ZenMaster

ASKER

MDB is not open in design mode; I using W95 for my mini-network; there are no permissions on the shares.

jjmartin

This is a stumper, generally you get a message like that when the DB is open. How are you accessing this MDB? Are you opening it through code, or using a data control. Perhaps you are inadvertantly trying to open the DB twice somewhere in the code?

Also, does this problem only accur when accessing the DB over the network. Try pointing to a duplicate DB on your local drive just to see if you get the same error. Then we can rule out any network problems.

ASKER CERTIFIED SOLUTION

majed100598

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ZenMaster

ASKER

I need a clarification from majed: I am using W95 in a peer-to-peer type system, I don't believe there are permissions on such connections outside of the read-only or full rights options on the shares. I know these are set to full access. Is there something I am missing?

ZenMaster

ASKER

It's kind of embarassing to admit, but the user got in and changed the share on the drive on the 'server'; changed that and the problem was fixed.