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

Also tried using the "runas" option to run app with the administrator account - it would not accept the username and password.

KB

I think you'll have to setup user accounts and give them permissions to Open/Run the database and objects.

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

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?

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

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)?

I would assume it installs runtime stuff since Access is not installed on the system.

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.

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.....

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