Help with Security...

[dgaletar]

Hello there. I need some help securing an Access database. I've never done anything like this before. I am about to put the database on a shared drive. I want myself to be able to do anything (of course), my co-worker Paul to be able to ONLY enter information (along with being able to view everything like forms and reports), and my boss to ONLY be able to view everything (form/report wise).

I found this post (http://www.mrexcel.com/forum/microso...ns-system.html) about how to secure a database. I spent all day doing it, but it didn't work at all! I just got a bunch of errors whenever I tried to do anything, so I deleted the database and re-used an earlier version.

Can anyone help me with this project???

Thanks,

DG

 

[bob fitz]

Can you post a copy of your db in A2003 mdb format.

 

[dgaletar]

OK. Here it is. Please let me know if it was not saved properly.

 

[bob fitz]

I can open the db if I use the shift key but trying to open the form "Welcome" causes it to crash. You may want to remove the db from your post as it appears to contain "real" data.

 

[dgaletar]

Not sure why it's crashing. And I'm not too concerned about the information in the database. It's just lawn mowers... lol But thanks!

 

[bob fitz]

Not sure why it's crashing. And I'm not too concerned about the information in the database. It's just lawn mowers... lol But thanks!

Sorry I can't be of more help

 

[dgaletar]

OK then... can anybody else with a more modern version of Access take a shot at this???