Printing Access Reports Remotely

D

DS

If you have an Access application on one machine at location A, can you
go onto it from Location B (Located offsite, another city, wherever)
view the reports on Location A, from Location B, and print them to a
printer connected to the computer at Location B, from Loction B? I'm
sure I'm complicating this more than I have to.....but any suggestions
or advice appreciated.
Thanks
DS
 
R

Roger Carlson

I'm not sure how much this will help, but on my website
(www.rogersaccesslibrary.com) is a small Access database sample called
"ReportInBackEndDatabase.mdb" that might help. It doesn't have to be a
back-end database, it will work with any other database. What I don't know
is how it will work over a WAN. At any rate, it's a start.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
D

DS

Roger said:
I'm not sure how much this will help, but on my website
(www.rogersaccesslibrary.com) is a small Access database sample called
"ReportInBackEndDatabase.mdb" that might help. It doesn't have to be a
back-end database, it will work with any other database. What I don't know
is how it will work over a WAN. At any rate, it's a start.
Click to expand...
I think its a network thing, I mean do you have to put access on the web
to do this? I know with PC Anywhere you can Access another computer but
you can't print to your computer, it goes to the computer your Accessing.
DS
 
A

Albert D.Kallal

There are a number of solutions to this problem.

You can read about the solutions here:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html


Of course, we assume that any competent developer has their database split.
If you just read the above, then you will understand that you can NOT run
this split across the web. However, you still need to be aware of this
correct setup. So, if you HAVE NOT split your database, then read the
following

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm
 
D

DS

Albert said:
There are a number of solutions to this problem.

You can read about the solutions here:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html


Of course, we assume that any competent developer has their database split.
If you just read the above, then you will understand that you can NOT run
this split across the web. However, you still need to be aware of this
correct setup. So, if you HAVE NOT split your database, then read the
following

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm
Click to expand...
Thanks Albert. Yes my Database will be split.
Ok, is there an easier way to get the Access reports to someone not on
Location? Maybe like E-Mailing them? Also can you send the BE file
somewhere else so that a person can use it with a utility to import into
their accounting program?
Thanks
DS
 
P

Peter-d

I use an excel spreadsheet for my users to capture data when they are away
from the network (e.g. laptop at home) with a function in my app that allows
to select an excel spreadsheet and import the data in it in appropriate
tables.

Maybe an export from one location/ import at another function would allow
you to share data from one site to the other. (you could use a secure mdb
file instead of xls for transporting the data if security is an issue)

Otherwise, if it's just the report you are interested in, you can maybe
generate a pdf from location A and email it to location b

Don't know if any opf this help, theiy are just hight level suggestions.
 
A

Albert D.Kallal

Thanks Albert. Yes my Database will be split.
Ok, is there an easier way to get the Access reports to someone not on
Location?
Click to expand...

A great way is to use a web server, and sql server reporting services. But,
then you are not using ms-access reports anymore.

And, you could have ms-access "generate" some reports, and save them to a
web server for all to view. (they would be static in this case..but often
this is good solution).

So, you either install the reports on the local machine, or you have the
local machine remote access the application + reports on your server (as
mentioned, Terminal services is a great way to do this if you do NOT want to
re-write any code at all).
Also can you send the BE file somewhere else so that a person can use it
with a utility to import into their accounting program?
Click to expand...

Ouch...now we are talking about a accounting program, and moving data from a
mdb file. (kind of a different topic...don't you think?). But, sure, I see
no
reason why you can't email a back end file. However, you likely don't want
that user to have "all" of the data in that mdb file. You likely are MUCH
better off to generate some type of excel, or csv (comma delimited) file
that
the other application can consume. Again, this file could be placed on a web
server for others to download.

What approach is comfortable is going to depend on if you have your own web
server, or it is hosted, or whatever.
 
D

DS

Albert said:
A great way is to use a web server, and sql server reporting services. But,
then you are not using ms-access reports anymore.

And, you could have ms-access "generate" some reports, and save them to a
web server for all to view. (they would be static in this case..but often
this is good solution).

So, you either install the reports on the local machine, or you have the
local machine remote access the application + reports on your server (as
mentioned, Terminal services is a great way to do this if you do NOT want to
re-write any code at all).




Ouch...now we are talking about a accounting program, and moving data from a
mdb file. (kind of a different topic...don't you think?). But, sure, I see
no
reason why you can't email a back end file. However, you likely don't want
that user to have "all" of the data in that mdb file. You likely are MUCH
better off to generate some type of excel, or csv (comma delimited) file
that
the other application can consume. Again, this file could be placed on a web
server for others to download.

What approach is comfortable is going to depend on if you have your own web
server, or it is hosted, or whatever.
Click to expand...
Albert, this sounds like the best, I could automate this to happen evey
night. I guess the customer would have to pay for some web space in
order to do this. But then again, whenever you sign up for internet
service you usually get a small web page with it. I guess this would be
suffcient.

Once again thanks Albert
DS
 
Top