Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MS Access permission issue

Posted on 2013-10-23
10
Medium Priority
?
245 Views
Last Modified: 2013-10-30
I have an application provided by a third party which uses an Access database.

The MDB was installed using  a Windows setup exe as provided by the third party.

The installation also included an MDW file.

I cannot access the MDB from my own Office 2010.

 I get a message "You do not have the necessary permission to use the '' object have your system administrator or the person who created the object establish the appropriate permissions"  

I have tried a command line switch following research and this prompts for a user name and password but then gives the same message as above.
0
Comment
Question by:TomPreen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
10 Comments
 
LVL 31

Expert Comment

by:hnasr
ID: 39593614
Probably requires an ADMIN password, to set appropriate user permissions.
Contact supplier, or check documentation.
Or you may reinstall application, and watch for a screen it asking for such a management user.
0
 
LVL 58
ID: 39593691
The application has been secured and as hnasr said, you'll need the correct username and password to access the database, so you'll need to contact the vendor.

Jim.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39593926
...In other words, you cannot open the mdb file directly...

Typically you would have a shortcut that points to the MDW file, then opens the mdb file...
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:TomPreen
ID: 39596567
My command line includes a value for the workgroup and the mdw file.

This then prompts for a user name and password.

Using the user name and password as provided I still get the permission message.

Any other values give the message 'invalid user name and password.
0
 
LVL 58
ID: 39596880
Everything you've said is normal.

<<Using the user name and password as provided I still get the permission message.>>

That simply means the user name your signing in with doesn't have permission to do what your trying to do.

 For example, if your trying to look at the table design, that user may have deny on table design, but can still read/write to the tables.

Jim.
0
 

Author Comment

by:TomPreen
ID: 39597148
So in order to use the user name and password I need to know the permissions that have been granted to the user name and password that I am using???


The minimum rights would surely be read only so how do I pre-define that?

Here is my command line (paths are dummies and not actual paths used)

"C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE" "c:\mdbpath\data.mdb " /wrkgrp "c:\mdwpath\system.mdw" /user
0
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 1000 total points
ID: 39597180
<<So in order to use the user name and password I need to know the permissions that have been granted to the user name and password that I am using???>>

  Basically yes.   You should be talking to your vendor about this.

  The user name / password you were given carries specific permissions.  That may be nothing more then being able to open certain queries giving you access to data and nothing else for example.    It also might be full permissions for everything and it's simply not working right.

  But what rights that login has have been determined by the author of your program and until you talk to them, you won't know if there really is a problem or not (ie. you might have been supplied with the wrong workgroup file, wrong user name/ password, etc).

  You should contact them, tell them what your attempting to do, and see if that is allowed or not.

  But what you've doing is correct.  Your just running into permissions that have been set and there is nothing "wrong" per say.

Jim.
0
 
LVL 58
ID: 39597288
Tom,

 Just to make sure we haven't gotten off the beaten path, are you simply trying to use the app with Office 2010?

 Normally, when an Access app is distributed, especially with a .EXE installer, a runtime version of Access is distributed as well and you should have had installed some type of short cut to access the app.

If so, does that work and are you using Office 2010 on it's own just to open the DB?  If that's the case, then what we discused is correct.

 But if you fundamentally can't use the application, then that's something else.

Jim.
0
 

Author Comment

by:TomPreen
ID: 39597388
The application has it's own exe which is working with no problems.

What I need to do is utilise the data maintained by the application for other reporting purposes in Office 2010.

I have also attempted to use Microsoft Query within Excel 2010 and this does not prompt for a user name and password but gives the same message that I reported in my first post,
leading me to believe it was a Windows 7 permissions issue
0
 
LVL 58
ID: 39597471
<<What I need to do is utilise the data maintained by the application for other reporting purposes in Office 2010.>>

 OK.   Then it is as we have been discussing.  The DB has been secured.

 You will need to contact them to get a username/password combination that allows access to the data.

Jim.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question