Access 07 software at work

[Bob76]

Been self-studying Access07 at home with test data from work. All databases
are presently in Excel 07 format. Now I feel am ready to show my boss how
Access07 can be more beneficial for our purposes. At present, there are 5
people who will be using these infos: myself (the only one who will be
actively updating/inputting data) and 4 others who will just be viewing (or
printing) the tbls/forms/reports. right now, we only hav Office 07 Standard.
My question is: is there some way to minimize the cost of having Access07
installed at work? Is it possible to have Access07 installed in my
workstation only and some way of having the other 4 just be able to view the
tables/forms/reports w/out full download of Access in their computers?
Someone mentioned about Snapshot viewer? how does that work? Is it only for
reports? Thanks.

 

[Fred Boer]

Be thankful! The Access runtime is free for downloading. Use a full version
of Access for developing on your computer, and install the runtime on
computers which will use the application.

http://www.microsoft.com/downloads/...D9-9DC6-4B38-9FA6-2C745A175AED&displaylang=en

Cheers!

 

[Bob76]

Thanks a lot!!! That's really great... Now i have more leverage to use
Access07 at work..was worried that if cost too high, this project might be
scrapped by my boss. My hours and hours of self study would have gone to
waste..

I went to this link you provided for runtime, it has this download called
"Access 07 - Developer Extensions" w/c optionally includes Access 07 Runtime.
is it better for me to download this or just the Runtime? Thanks again...

 

[Fred Boer]

Glad you've found the Runtime. Sorry, I haven't used the Developer Extension
so I can't provide an informed opinion - maybe someone else will jump in -
otherwise, repost asking about that!

Cheers!

 

[roccogrand]

Bob,

The 2007 Runtime requires doing things differently than with earlier
versions. I suggest that you read and understand all the caveats that MSFT
and others have published. If you don't follow their suggestions you could
find your code disappearing without warning.

LDN

 

[Tony Toews [MVP]]

The 2007 Runtime requires doing things differently than with earlier
versions. I suggest that you read and understand all the caveats that MSFT
and others have published. If you don't follow their suggestions you could
find your code disappearing without warning.

Do you mean the trusted locations setting where the code doesn't
execute? If not what do you mean by the runtime causing code to
disappear?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Bob76]

Hi,

What do you mean by "code disappearing"? Can i not send via email or copy
from my USB my Access file in format .accdb to another person's computer
using this Runtime 07, without having the full version of Access07 installed
in this person's computer? Then he/she can view the tables/forms/reports
that I created?

Thanks, Bob76

 

[roccogrand]

There is a problem with versions of Access 2007 that have not been patched.

In addition, John Viescas and Jeff Conrad in "Access 2007 Inside Out" has an
extensive list of actions that users need to consider when using the Runtime
(see page 1328). As I recall, a similar list is on the Microsoft website
somewhere.

The code disappearing problem has now happened to me a couple times with the
same client on their network. First with users having Full and Runtime
Access, and now with none having Runtime.

Microsoft apparently issued a hotfix in August, that may fix the problem.
In the morning, I will be replacing the code again behind two forms for the
second time. It's an easy thing to do but the drive into town is 45 minutes
each way.

To answer your question directly Bob, the answer is yes. However, the code
behind some of your form could disappear in a networked environment without
warning. So implement Runtime using the instructions in Access 2007 Inside
Out.

There are other mentions of this problem on the Net.

LDN

 

[roccogrand]

Bob,

If you need to support remote users like I do, a service like
securelogmein.com can be a real life saver. I was just able to copy the
missing code from my backup into the client's application from home. This
saved me an hour and a half of driving for a ten-minute fix. I still need
to install the hotfix but the code behind the form works now.

LDN

 

[Bob76]

Thanks a lot for your insight and suggestions....I will check out the book
"Access 2007 Inside Out".. I hope I can get this Runtime to work, try it out
first before presenting to my boss.