Hi There,

I converted our Access database to adp front end and sql 2000 db as
back end. Every things is working fine except user permision. When i
distribute the adp file to our staff they could not able to open some
of the report and form, say permision not given, those form or report
in base on DBO permission. But when i give that user system
administrator permission, they can access all the form and talbe,
report etc. Is there any way they can access all the form, query or
report without system administrator group.

The 2nd problem is how can i asign different permision to differnt
users. I want some of the user to not able to even open the talbe or
query except forms or report and some to have full permission. Write
now every one is able to open and modify the talbe etc. Is there any
way to solve this problems. I wanted to rollout this project with this
week but because of this proble i am really getting stop. Please help
me if there is any information about this.

Thanks in advance.

Indra.