How to share Access report from Linked SQL DB

[cobolguy]

I have a simple report that I need to share with some other users. The report is generated in Access from a Linked SQL Server Database. I would like some simple ideas on the best way to get this report in the hands of a few users. It is currently only on my computer. Thanks in advance for support.

[NeoPa]

Generally print to PDF format (native in Access 2007 but requires extra software in earlier versions I believe).

I'm assuming giving out a copy of the database is not a practical option.

[cobolguy]

Thanks NeoPa for the reply. I like the idea of the PDF - but I still need for the bookkeeper to run the report. Yes I could run it and send her the PDF, but I want to be invisible in the process. I want to design a form that has a button to let her run the report. I'm not sure how to give a copy of a linked SQL database to another user? I am using the 2007 version.

[NeoPa]

You can send a copy of your database of course. If it relies on a link to a back-end source of any kind this will need to be set up separately.

[cobolguy]

I have worked with our Tech and found a workable solution as you described. I did a backup of the database to a Kingston USB drive and we carried this to another computer. Since the backup stores all of the link information we simply had to configure the ODBC connection (first screen is ODBC Data Source Administrator). Once the connection was established we could run the queries I wrote on my local machine. Next step will be to put this database on a Server instead of my Kingston. Now - not only can I write queries but also Forms and reports. Nice when all the steps finally works. I am sure another solution lies with SharePoint. Thanks again.

[NeoPa]

It's a pleasure. Good to hear that you've taken it and run with it to a successful result :)