runtime or ??

[Bob76]

I need to send my Access2007 tables, forms & reports to 3 people in our
office who don't have the full version of Access07. A while back, in this
discussion group, someone suggested the downloading AccessRuntime. Is it
sufficient for me to download AccessRuntime or do I have to download
AccessDeveloper Extensions? How does the runtime work? I've been reading
about it and am having difficulty understanding the concept.
Recently, an IT friend of a co-worker suggested the site: OpenOffice.org.
Has anyone heard of this? I read about it and seems like its origin is
Germany and their version "Base" is simulating MSAccess. I was told this is
another way to deploy my Access database to someone w/ no full version of
Access. AM hesitant in downloading this free system bec i never heard of it
before.. Any suggestion is appreciated.
Thanks, Bob

 

[Allen Browne]

For yourself, grab the runtime and developer extensions. This will let you
create an install package for your users.

For testing purposes, you will want a machine that does not have Access, to
see that your package installs and runs successfully. Alternatively, use
Virtual PC or similar to run your tests.

The A2007 runtime actually works well provided you have designed your
application correctly, e.g.:
- Avoid ActiveX controls that may not be in the user's system (or where the
versions may not be identical.)

-Ensure you have error handling in all routines.

-No macros without error handling (other than specialized ones that
RunCode.)

Base is not an Access clone. It's an entirely different beast. There's no
point developing something in Access, and then trying to convert it to Base.
That would be about as useful as getting your pilot licence in preparation
for a swimming race.

 

[Bob76]

What do you mean by Virtual PC? How do i do that?
I tried downloading the runtime once before and did the installation..but i
couldn't find it anywhere to check it out .. is it bec I have the Access07 in
my computer?

 

[Allen Browne]

The runtime disappears from the Office button in A2007, it's probaby because
you are running multiple versions of Access:
http://support.microsoft.com/kb/937998

Info on Virtual PC:
http://windowshelp.microsoft.com/Windows/en-US/Help/97a74f0e-798d-45ff-b9bf-7feed68c40e51033.mspx

http://www.microsoft.com/downloads/...02-3199-48A3-AFA2-2DC0B40A73B6&displaylang=en

Other generic stuff on adapting to A2007 if you are familiar with previous
versions:
http://allenbrowne.com/Access2007.html

 

[Bob76]

Thanks a lot for all your help, i found all the links you sent very
informative... will try the Virtual PC tonite.