Access 2007 Runtime and linking to back end and printing

R

Rose B

Hi,

I am just starting to 'dip my toe in the water' with Access 2007 Runtime and
have come across two immediate problems - that I am sure someone out there
has an answer to!

1. How do you send a new Runtime of an application to a user and get it
linked to the correct back end in their environment? (Until now I have been
created mde files on my XP machine under Access 2002 so that all users can
use it - they range from 2002 to 2007 Access; I would prefer to do everything
on my 2007 machine if possible from now on).

2. How can I get simple things, like printing a report, to work under
Runtime? Do I have to develop application 'features' to do this? (There may
well be other things like this - I do try and minimise the amount that a user
needs to use the standard ribbons for - but there are bound to be more)

Thanks in advance,

Rose
 
R

Rose B

OK - scrub the question about printing - found that! But another one would be
exporting to Excel or Word.... guess I need to create application buttons to
do this?
 
P

Peter Hibbs

Rose,

Glad to be of help.

Peter Hibbs.

EXCELLENT!!! Thanks Peter, I have put the code in and created a runtime and
tested (albeit onlt on my PC at the moment) in a different folder and it
worked great!
 
A

Albert D. Kallal

You have some answers for the table linking. I think everyone very much
cobbles together some code that can re-link at startup.

As for the report, again it usually a good idea to provide a custom ribbon
for that report. I have one such here:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm
(grab the download called Access 2007 report ribbon example (with PDF and
email)

And, for deploying updates, check out the following article of mine:
http://www.members.shaw.ca/AlbertKallal/RunTime/Index.html

And, for a good discussion of other ideas for deploying updates, read this
thread at UA:
http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1806138&page=&view=&sb=5&o=&fpart=1&vc=1
 
R

Rose B

Thanks so much for this Albert - I have a lot of thinking/testing to do!
Looks like using the runtime will not actually solve my first problem - which
is that some of my user's have an older version of MS Access that I have on
my 'main' PC, so every time that I create a front end I have to remember to
go and create it on my older PC so that it will work on their machines. This
seemed (initially) like a good way to get a common deployment, with all the
latest 2007 features, to the users..... and allow me my moments of amnesia
when I forget to go to my old PC (which I am worried will give up the ghost
one day!) just to create the front end. Ho hum!

I have downloaded the installer (also recommended by Peter) and the report
ribbon, read your article (thanks for that - all makes sense) and read some
of the discussion - will go back to that soon.

Thanks again!

Rose
 
T

Tony Toews [MVP]

Rose B said:
Thanks so much for this Albert - I have a lot of thinking/testing to do!
Looks like using the runtime will not actually solve my first problem - which
is that some of my user's have an older version of MS Access that I have on
my 'main' PC, so every time that I create a front end I have to remember to
go and create it on my older PC so that it will work on their machines. This
seemed (initially) like a good way to get a common deployment, with all the
latest 2007 features, to the users..... and allow me my moments of amnesia
when I forget to go to my old PC (which I am worried will give up the ghost
one day!) just to create the front end. Ho hum!

Indeed I still ship one of my apps in A2000 format although with the
A2003 runtime but I have a few customers of that app still on the
A2000 runtime. There's nothing that useful in A2003 as far as the my
users are concerned other than conditional formatting of a continuous
form.

Tony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top