Access 2000 Runtime with Access 2007 Installed

[Paul Fenton]

A couple years ago, I developed an application for a friend, using
Access 2000. He's been running it successfully in his office on about
12 workstations which run Office 2000.

He's in the process of purchasing new computers for all his employees
and wants to buy Office 2007, but doesn't want to spring for the extra
$$$ to get the version that contains Access. The program I developed
for him requires installation of Access. It's not runtime.

On my old computer, before it crashed, I created a runtime package
(Developer 2000 version), but when I try to install it on my new one,
running Office 2007, it says it needs Access 2000 to run.

I'm not sure what our options are at this point. Could use some help

Run Access 2k and 2007 at the same time? Office 2k and 2007?


Paul Fenton

 

[Albert D. Kallal]

I'm not sure what our options are at this point. Could use some help

Run Access 2k and 2007 at the same time? Office 2k and 2007?

Why not just convert the application to access 2007. You then install the
runtime on all of the machines. For access 2007 the runtime is free, and so
is the package wizard. On the other hand you really don't need to use the
package wizard - just install the runtime on each pc. After you have
installed the runtime, then you can simply copy any mdb, or accDB file to
that computer and the application will run. (however, it best to keep the
applcation in the same version.

So, keep in mind that the runtime system never had any connection between
the application you installed and any other database that you run on that
particular computer. (you can just copy the acccdb files to that computer
with the runtime, and when you double click on the file...access will launch
and run.

It seems to me the easiest solution here is simply to convert the
application to 2007, and then simply copy the application to the machines
you need. So, simply install the free 2007 runtime on each computer you
need.

 

[Paul Fenton]

Albert, thank you for the reply. A couple questions...

Is the runtime embedded somewhere in Access 2007 along with the
package wizard or do I need to download it or something?

What do you mean when you say "install the runtime on each machine"?
Is it a file somewhere in the Office package or do I have to get it?

Thanks again

Paul Fenton

 

[Albert D. Kallal]

Albert, thank you for the reply. A couple questions...

Is the runtime embedded somewhere in Access 2007 along with the
package wizard or do I need to download it or something?

It is a seperate download. Here:
http://msdn.microsoft.com/en-us/office/bb229700.aspx

What do you mean when you say "install the runtime on each machine"?
Is it a file somewhere in the Office package or do I have to get it?

Yes after you download the runtime, simply install it on the target
machines. The point that I was making is that even in the past you really
never had to connect your application to the runtime.

In other words the installing of the runtime of MS access onto a computer is
actually a separate operation than that of installing your application
you've built. While it turns out that you often package the runtime + your
application together, that's not a requirement.

The access runtime always been simply a stripped down version of MS access,
and once it's installed on the target machine you don't need the package
wizard. You can simply copy a file by drag and drop from the network or even
from a usb jumb drive. There is really no "install" of your applcations, but
simply the placing of the file on the computer does the trick. You can then
click on any database and it will run.

I guess I'm just trying to point out that it's a common misconception that
there's some special connection between the application you built and that
of the runtime. There's no such special connection.

 

[Paul Fenton]

I understand perfectly Albert. Thanks for clearing it up and thanks
again for your help.

Paul Fenton

 

[Paul Fenton]

I understand perfectly Albert. Thanks for clearing it up and thanks
again for your help.

Paul Fenton