470,602 Members | 1,649 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,602 developers. It's quick & easy.

How to share Access report from Linked SQL DB

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.
Jun 16 '09 #1
5 1679
32,299 Expert Mod 16PB
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.
Jun 17 '09 #2
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.
Jun 17 '09 #3
32,299 Expert Mod 16PB
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.
Jun 18 '09 #4
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.
Jun 19 '09 #5
32,299 Expert Mod 16PB
It's a pleasure. Good to hear that you've taken it and run with it to a successful result :)
Jun 19 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Gheaci Maschl | last post: by
5 posts views Thread by Rich | last post: by
52 posts views Thread by Neil | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.