Sharing a live report securly.

[charlestdenver]

Does anyone one have a good idea for distributing a live report written in access without giving the receipients access to the tables and views in the database window. The project is tied to a sql server. I could hide the database window at startup but the options for a startup screen are a form or a page. The report designer is much easier to use and the receipients are not allowed to modify the data.

 

[dhookom]

Have you considered using pass-through queries for your reprot's record source? The pass-through records can't be edited and the performance is generally much better.

Duane
Hook'D on Access
MS Access MVP

 

[charlestdenver]

The record source for the report is a query, and the data for it is safe. What I need is an easy method to format it into a report that doesn't give the end user any access to the database. The subtotals and totals that can easily be put on an access report are what I'm trying to share, but with real time data. I could do this with .asp or possibly Excel but if I could just share the report it would be so much easier.

 

[dhookom]

I was going to mention ASP which I think would be less work than securing the database. I also do a fair amount of reporting using Excel and ADODB or DAO.

Duane
Hook'D on Access
MS Access MVP