Access to SQL Server

I have a diagram that is maid in Access 2000. Is it posible to import it to SQL Server 2000No.
You can try with VISIO to do so.

Access permissions in RS

I was wondering if is posible to set user to view certain reports only, using the active directory user credential. example user 1 can view 3 reports, user 2 can view 5 reports admin user can view all......etc.

I would set up groups on your Active Directory, and then assign people to those groups. Once you have all that set up, you can assign report permissions to certain groups only.