Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 437
  • Last Modified:

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?
0
ZenMaster
Asked:
ZenMaster
1 Solution
 
mukvijCommented:
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.
0
 
ZenMasterAuthor Commented:
MDB is not open in design mode; I using W95 for my mini-network; there are no permissions on the shares.
0
 
jjmartinCommented:
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.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
majed100598Commented:
I thing the problem is with user permission when you make a map drive , try to check the user privellages
0
 
ZenMasterAuthor Commented:
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?
0
 
ZenMasterAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now