By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,486 Members | 1,749 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,486 IT Pros & Developers. It's quick & easy.

How to share Access report from Linked SQL DB

P: 19
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
Share this Question
Share on Google+
5 Replies


NeoPa
Expert Mod 15k+
P: 31,709
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

P: 19
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

NeoPa
Expert Mod 15k+
P: 31,709
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

P: 19
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

NeoPa
Expert Mod 15k+
P: 31,709
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.