Adding A User In a Password Protected Database

[stillcrazee]

I use a database that someone else set up and is no longer here. To get access to the database you need to enter a user id and password. I have a new user who has been getting into the database using an established user's id and password.

I went into the file and found the table with the users, their id's and passwords listed, and added the new person to the table, but I still get an invalid user message when trying to access the database with the new user's information.

I went through the Access Help and tried a couple things it said for adding users to a password protected database, but either I didn't do it right, or the way to add a user is different from what I am getting from Access Help.

Lastly, this database is different in that if I would add a report, it only shows up on my computer when I access the database, the report doesn't show up on anyone else's. That is odd to me, but it is how it works.

Thank you for any help you can give.

 

[KKilfoil]

Your db is likely split into a front end / back end (FE/BE) structure.

Each user has their own FE containing the forms, queries, reports, etc (probably on their individual PC hard drives) while the single copy of the BE containing all of the tables (and therefore the actual data) is on a network drive and linked to each FE. So a change to YOUR copy of the FE is local to you.

Search this forum for 'front end' and you'll get lots of useful threads on this concept.

 

[MrsGorilla]

Also it sounds like the database has user-level security applied. Have you tried looking under the Tools-->Security-->User and Group Accounts menu to add a new user? You would need to add someone there and give them access to the group(s) they need.