How can implement Security on Access Report ?

I develop FORM in ACCESS and make Report in ACCESS
ACCESS report table are link with the SQL SERVER 2000 .
All data retrieve from the sql server tables.
I link the FORM with the INTRANET site.
When user click the FORM, ACCESS REPORT run and display data information.

But it have no security, in this way user can changes in the SQL SERVER Tables.

Because user can open the SQL SERVER table.

How can implement security on ACCESS Report that only user can see the Report only ?

And does not any changes in the sql server tables ?

 Regards.

Mateen

use a view and lock it to everyone as read only.

Do nt link your tables to your front end.





Sal

thanks for response.

view can automatically will update ?

or every time after data entry create view and then link
with the report ?

because tables will frequently will update.

regards.

Mateen

are you trying to give some users the ability to only view reports?

If that is the case, give them only read access to the data. I guess your question is not clear to me.


You say that you have "no security". Take care of tha first. secure all the data using security in SQL Server and give users only the rights they need. Access security is useless. the important think is not to keep the user from changing objects in access, but changing data in SQL Server.



Sal

yes

I want to give some users the ability to only view reports

My question is that how view will update ?
view will automatically will update or
it need to update the view ?

becuase program's table is dynamic (data frequently change)
if view not update ie. it will display old data ?

I will implement security on sql server tables that
user only see the report.

Mateen

Forget what I said about the view. Just implement security so that the users for these reports get only "read" permissions to the data.



Sal

thanks for response.
before this, I ask one thing,

I give users to only "read" ie "select" permissions to the data
in sql server 2000.

but can users insert and update the data by the ASP program ?
ASP program runing on intranet,


Mateen

Use a view for the report and set it to read only for everyone. I guess I am getting confused.
Re-think your security model, if you do not have one, create one soon.



Sal

thanks.