• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2527
  • Last Modified:

[Microsoft][ODBC Microsoft Access Driver] Not a valid password

The following error ONLY occurs with non-administrator accounts. Tried entering username/password of "admin" for User DSN tab, datasource "cdo microsoft access driver *.mdb", click configure, then advanced. However the same error occurs (admin username/password is the account used to gain full access to DB.  

How can I get this driver to work on non-admin accounts?

Application is CD Organizer 4.0.2, WIN XP SP2 with all updates installed.

KB
0
kbryant2
Asked:
kbryant2
  • 6
  • 5
1 Solution
 
kbryant2Author Commented:
Also tried using the "runas" option to run app with the administrator account - it would not accept the username and password.

KB
0
 
ArjiCommented:
I think you'll have to setup user accounts and give them permissions to Open/Run the database and objects.
0
 
kbryant2Author Commented:
I have done that but when this error occurs I never get a login prompt. I don't think it's the access database but the ODBC driver. Of course just a conjecture on my part - I am not a access programmer. The variable here appears to be whether or not the windows XP user account has admin rights or not.

KB
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
ArjiCommented:
Is this a commercial Access application? Are you trying to use Access security or Windows security?  The ODBC driver doesn't have anything to do with the access workgroup. If you've setup a Access workgroup and you're not getting a login prompt you aren't joined to the workgroup.  Have you assigned the admin account of the Access workgroup a password?
0
 
kbryant2Author Commented:
Commerical - the application came with the device it manages. I downloaded the latest version off the net. The Access application has a user management utility which I used to create the user accounts. I understand what you are saying about the Access workgroup and I don't think it applies since the application is commercial. The application does come with a "admin" account built in which is used to create user accounts within the application.

KB
0
 
ArjiCommented:
Does the app use your existing Access version or does it install the Access runtime stuff?  Is it possible you are joined to the default system.mdw workgroup(only possible if you already had access on the system)?
0
 
kbryant2Author Commented:
I would assume it installs runtime stuff since Access is not installed on the system.
0
 
kbryant2Author Commented:
I never did indicate the entire error message. Here it is - (Failed to connect to datasource: [Microsoft][ODBC Microsoft Access Driver] Not a valid password). I hope this helps.
0
 
ArjiCommented:
Usually a commercial app that utilizes Access security will supply it's own .mdw file and the app will automatically sign in it to it upon startup or runtime.  Not sure what your app is doing.   One more thing...does the Admin account have a default password or is the password blank for startup?  Access security does not start working until the Admin account has been assigned a password.  Hope that helps.....
0
 
kbryant2Author Commented:
Yes the admin account has a password. Did some more experimenting. I can give a user Windows XP admin rights, open the database, logout, take away Windows XP admin rights and login again and the CD Organizer database opens ok! However if I logout and try a different user that does not have Windows XP admin rights I get another ODBC error that says it can not get exclusive access to database. I suppose running the app with the windows xp admin login (aka runas command) would work but it didn't - kept saying invalid password. I think I will call their tech support guy, and if he can not help. Then I will try to setup XP to allow any user to have full rights to the program files directory. I think the issue is XP home and it permissions.

KB
0
 
ArjiCommented:
KB,

You really should only need to assign Read/Write access.  You don't want your users to be able to delete the database and files.  Just don't give them delete privileges.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

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