Access 07 software at work

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.

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/d...displaylang=en

Cheers!
--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available he
http://www3.sympatico.ca/lornarourke/


"Bob76" wrote in message
...
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.

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" wrote:

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/d...displaylang=en

Cheers!
--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available he
http://www3.sympatico.ca/lornarourke/


"Bob76" wrote in message
...
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.

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!

--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available he
http://www3.sympatico.ca/lornarourke/


"Bob76" wrote in message
...

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" wrote:

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/d...displaylang=en

Cheers!
--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available he
http://www3.sympatico.ca/lornarourke/


"Bob76" wrote in message
...
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.

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


"Fred Boer" wrote:

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/d...displaylang=en

Cheers!
--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available he
http://www3.sympatico.ca/lornarourke/


"Bob76" wrote in message
...
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.

roccogrand wrote:

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/

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" wrote:

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


"Fred Boer" wrote:

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/d...displaylang=en

Cheers!
--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available he
http://www3.sympatico.ca/lornarourke/


"Bob76" wrote in message
...
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.

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

"Bob76" wrote:

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" wrote:

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


"Fred Boer" wrote:

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/d...displaylang=en

Cheers!
--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available he
http://www3.sympatico.ca/lornarourke/


"Bob76" wrote in message
...
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.

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

"roccogrand" wrote:

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

"Bob76" wrote:

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" wrote:

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


"Fred Boer" wrote:

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/d...displaylang=en

Cheers!
--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available he
http://www3.sympatico.ca/lornarourke/


"Bob76" wrote in message
...
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.

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.


"roccogrand" wrote:

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

"Bob76" wrote:

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" wrote:

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


"Fred Boer" wrote:

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/d...displaylang=en

Cheers!
--
Fred Boer - Amateur Access Enthusiast
Interests: Library software / Z39.50 / Web Services
Freeware Small Library Application available he
http://www3.sympatico.ca/lornarourke/


"Bob76" wrote in message
...
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.