Viewing Access report

[cjany]

I have created a report in Access and would like other users to view it, but I don't want them to see the database. What is the best way to distribute this report?

 

[PHV]

Have a look at snapshot.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cjany]

They would need to view this report everyday and it has a date parameter, so they need to see an updated report.

 

[dRahme]

Hi, to elaborate a bit on what PHV said - you can point everyone to a directory that contains the snapshop file and update as needed:

Dim myDir

myDir = Dir("C:\Snapshots", vbDirectory) 'Check to see if directory exists

If myDir = "" Then
'Need to create Directory
MkDir ("C:\Snapshots")
End If

'If Directory has File, Empty the Directory
If Dir("c:\Snapshots\*.*") > vbNullString Then
Kill ("c:\Snapshots\*.*")
End If

'Output reports to Snapshot Format

DoCmd.OutputTo acOutputReport, "YourReport", acFormatSNP, "C:Snapshots\YourReport.snp"


Hope that helps

 

[obli]

This is a simple solution I came up with for distributing a current employee phone list. On the form's Save button I attached the following code and created shortcuts on the users' desktops which point to the snapshot. Whenever the personnel clerk updates the phone list and saves it, an updated snapshot is available for viewing.

Private Sub Command113_Click()
On Error GoTo Err_command113_Click

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.OutputTo acOutputReport, "employeelist", acFormatSNP, "\\MyServer\MySharedFolder\Employee Phone List.snp"

DoCmd.Quit

Exit_command113_Click:
Exit Sub

Err_command113_Click:
MsgBox err.Description
Resume Exit_command113_Click

End Sub

 

[cjany]

This is a report that comes from live data so the data is updated all of the time and I don't want to have to open this report and save as a snapshot everyday. I want the user to pull the updated report on their own without seeing the database.

 

[dRahme]

Well, you can create another db and link to the necessary tables. In the new db, select a startup form and on that forms' onLoad event, open the report. On the report's close event, shut down the db.