Security Issue with IOA

[Garryg]

I developed an Access DB for a client in Office 2000. This database uses customer tables from another Access Database (Integrated Office Accounting "IOA&quot. The IOA database has several users with passwords. The administrator is "Shelley" and password is "First". The created database "Case Management" is accessed using the following target c:\Program Files\...\access.exe wrkgrp/ "C:\ioa\ioasec.sdw" "c:\case Management.sdb". I am able to open the database with the different user names (passwords are not required). e.g. Open the database with user "Shelley" and no password. Although the user "Shelley" is the administrator for IOA, she does not have admins rights for Case Management. I can log into Case Management with user "Administrator" and no password but again have no admins rights. Using Security menu I can see that there are several users of Case Management that have admins rights but I cannot find a password that will allow me to access admins rights. I have tried copying all the objects into a new database in which I have established admins rights but even though I use the same target as noted above I now have no access to IOA customer tables. Am I looking at this incorrectly or is there another way around this? All I need to do is set up a new user in Case Management or even change an existing user name and password.

 

[lameid]

You would have to copy over the database file (after backing it up) with the one with stripped permissions or point to the copy ("even though I use the same target as noted above I now have no access to IOA customer tables&quot.

Look into Run With Owner's Permissions (RWOP) queries. If the issue is that a user changed passwords and can't remember the new one, restore the older workgroup file before the password was changed and use the old workgroup to log on. You could then make your RWOP query, use the RWOP query instead of the table and use the current workgroup file instead of the old restored one. Because queries are slower than tables, you may want to keep the old workgroup file and strip out all the users but the one you need and modify the query programatically by opening a workspace logged on as the owner.

You need to know the user that is the owner of the database and log in as it to change passwords.

Whoever created the database likely has the keys used to create the workgroup file and could create a new one for you (or give you the keys so you could do it yourself). If IOA is a program that installs, you may be able to install it on a different machine to get the default workgroup which should have default users in it. There is the possibility that the author truly understood Access security and a random key is created at installation in which case your stuck.

That's all my thoughts... hope one helps