473,507 Members | 2,416 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Versions of Access needed A2K MDE? Runtime?

1) Is there a free runtime version of Access available that is more recent
than the one for Access 2000?

2) If I create an application (MDE) in A2K, will it run on all later
versions of Access?

3) If I create a CD using A2K Developer that includes the runtime version of
Access 2K and an installation package, and if someone tries to install the
application from the CD, what happens if someone already has Access 2000 or
a later version on their PC? Does it try to install the runtime anyway or
is it smart enough to know that the runtime will not be needed?

--
Regards,
Peter
Nov 12 '05 #1
14 4156
TC

"wolftor" <wo*****@rogers.com> wrote in message
news:Sm*******************@news01.bloor.is.net.cab le.rogers.com...
1) Is there a free runtime version of Access available that is more recent than the one for Access 2000?
AFAIK, there has never been, and never will be, a "free" version of the
Access runtime.

2) If I create an application (MDE) in A2K, will it run on all later
versions of Access?
I don't have Access here to check, but from memory, I believe the online
help for Access 97 specifically stated that MDEs would not work on future
versions. It's unlikely that this rule will change, IMO.

3) If I create a CD using A2K Developer that includes the runtime version of Access 2K and an installation package, and if someone tries to install the
application from the CD, what happens if someone already has Access 2000 or a later version on their PC? Does it try to install the runtime anyway or
is it smart enough to know that the runtime will not be needed?
Don't know.

HTH,
TC


--
Regards,
Peter


Nov 12 '05 #2
To your last question -
If you run an installation package which includes a runtime on a machine
where that version of Access is already installed, the runtime will not be
installed.
If however, for instance, you run a package with A2K runtime on a
machine where Access 97 is already installed, A2K runtime *will* be
installed.

HTH
- Turtle

"wolftor" <wo*****@rogers.com> wrote in message
news:Sm*******************@news01.bloor.is.net.cab le.rogers.com...
1) Is there a free runtime version of Access available that is more recent than the one for Access 2000?

2) If I create an application (MDE) in A2K, will it run on all later
versions of Access?

3) If I create a CD using A2K Developer that includes the runtime version of Access 2K and an installation package, and if someone tries to install the
application from the CD, what happens if someone already has Access 2000 or a later version on their PC? Does it try to install the runtime anyway or
is it smart enough to know that the runtime will not be needed?

--
Regards,
Peter

Nov 12 '05 #3
"MacDermott" <ma********@nospam.com> wrote in message
news:bu*****************@newsread2.news.atl.earthl ink.net...
To your last question -
If you run an installation package which includes a runtime on a machine
where that version of Access is already installed, the runtime will not be
installed. [snip]


That's not exactly correct. The Runtime "environment" is installed regardless
of whether the licensed product already exists or not. It just uses the
existing folder locations when a licensed version is present. Additionally; if
the Access executable in your Runtime package is newer than the one already
present the existing one is replaced.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #4
Does anyone know the answers to questions 1 & 2?
Also, If I create my mde in Access97 (still my favorite version because of
how simple it is to double click on a subform to open that subform), and
package it with the runtime, will the app work if the user has other
versions of Access (or no Access at all) and other versions of Windows than
was used for packaging?
"wolftor" <wo*****@rogers.com> wrote in message
news:Sm*******************@news01.bloor.is.net.cab le.rogers.com...
1) Is there a free runtime version of Access available that is more recent
than the one for Access 2000?

2) If I create an application (MDE) in A2K, will it run on all later
versions of Access?

3) If I create a CD using A2K Developer that includes the runtime version of
Access 2K and an installation package, and if someone tries to install the
application from the CD, what happens if someone already has Access 2000 or
a later version on their PC? Does it try to install the runtime anyway or
is it smart enough to know that the runtime will not be needed?

--
Regards,
Peter

Nov 12 '05 #5
wolftor previously wrote:
1) Is there a free runtime version of Access available that is more
recent
than the one for Access 2000?
No version of the Access runtime has ever been free.
If you are using a 'free' version then you are using an unlicensed
version.
2) If I create an application (MDE) in A2K, will it run on all later
versions of Access?


Probably, if it doesn't include references for other products.
(All can only be 2002 and 2003 - who knows what will happen after that)

Regards

Peter Russell
Nov 12 '05 #6
SA
A2000 mdes are able to be run currently in Access 2002 (Xp) and in Access
2003; they all use the Jet 4.0 engine....
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"Peter Russell" <ru***@127.0.0.1> wrote in message
news:me**********************@russellscott.btinter net.com...
wolftor previously wrote:
1) Is there a free runtime version of Access available that is more
recent
than the one for Access 2000?


No version of the Access runtime has ever been free.
If you are using a 'free' version then you are using an unlicensed
version.
2) If I create an application (MDE) in A2K, will it run on all later
versions of Access?


Probably, if it doesn't include references for other products.
(All can only be 2002 and 2003 - who knows what will happen after that)

Regards

Peter Russell

Nov 12 '05 #7
Perhaps I'm not clear on just what you mean by the runtime "environment".

I don't have direct access to the client sites at this point, but I'm pretty
sure I've had sites where the full Access 97 and the Runtime Access 2000
co-existed.

As I understand what you're describing, if for example a full version of A2K
was installed on a PC, and I executed an install package with A2K runtime,
the full version would be disabled and only the runtime would work. That
would not make me a happy customer.

Is there something I'm misunderstanding here?
- Turtle

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:bp*************@ID-98015.news.uni-berlin.de...
"MacDermott" <ma********@nospam.com> wrote in message
news:bu*****************@newsread2.news.atl.earthl ink.net...
To your last question -
If you run an installation package which includes a runtime on a machine where that version of Access is already installed, the runtime will not be installed. [snip]
That's not exactly correct. The Runtime "environment" is installed

regardless of whether the licensed product already exists or not. It just uses the
existing folder locations when a licensed version is present. Additionally; if the Access executable in your Runtime package is newer than the one already present the existing one is replaced.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 12 '05 #8
"MacDermott" <ma********@nospam.com> wrote in message
news:_q****************@newsread1.news.atl.earthli nk.net...
Perhaps I'm not clear on just what you mean by the runtime "environment".

I don't have direct access to the client sites at this point, but I'm pretty
sure I've had sites where the full Access 97 and the Runtime Access 2000
co-existed.

As I understand what you're describing, if for example a full version of A2K
was installed on a PC, and I executed an install package with A2K runtime,
the full version would be disabled and only the runtime would work. That
would not make me a happy customer.

Is there something I'm misunderstanding here?
- Turtle


I didn't mean to imply that the installation of the Runtime would disable the
licensed version. Only that it still gets installed.

If the setup program sees no licensed installation of Access then it installs
itself in a subfolder of the application being installed. If it sees there is a
licensed version installed it uses that existing folder location instead. It
will still replace any files in the existing Office folder that are older
versions than that being installed by the Runtime (including the Access
executable) and it will install the files and registry entries to support the
Runtime. On such a machine for example the /Runtime switch can be used whereas
on a machine with only the licensed version it cannot (unless its the
Developer's Edition).

Mind you, I have seen the scenario you describe above under certain
circumstances.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #9
TC

"wolftor" <wo*****@rogers.com> wrote in message
news:8P******************@news04.bloor.is.net.cabl e.rogers.com...

(SNIP)
Does anyone know the answers to questions 1 & 2?

Yes, I gave them to you. Did you not see them?

TC

Nov 12 '05 #10
TC
But I believe the policy is, an MDE will not >necessarily< run on every
higher version of Access.

The issue is surely not the version of Jet; it is the version of the
compiled sourcecode.

No? Yes?

TC
"SA" <~f***********@nspm.com> wrote in message
news:bp**********@ngspool-d02.news.aol.com...
A2000 mdes are able to be run currently in Access 2002 (Xp) and in Access
2003; they all use the Jet 4.0 engine....
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"Peter Russell" <ru***@127.0.0.1> wrote in message
news:me**********************@russellscott.btinter net.com...
wolftor previously wrote:
1) Is there a free runtime version of Access available that is more
recent
than the one for Access 2000?


No version of the Access runtime has ever been free.
If you are using a 'free' version then you are using an unlicensed
version.
2) If I create an application (MDE) in A2K, will it run on all later
versions of Access?


Probably, if it doesn't include references for other products.
(All can only be 2002 and 2003 - who knows what will happen after that)

Regards

Peter Russell


Nov 12 '05 #11
SA
TC:

If you've opened a copy of Access 2002 or 2003 lately you'll find that they
know how to read A2000 formatted dbs, mdb, or mde. Heck you can even
reference an A2000 mde from an A2K2 mdb without problem.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"TC" <a@b.c.d> wrote in message news:1069030712.627435@teuthos...
But I believe the policy is, an MDE will not >necessarily< run on every
higher version of Access.

The issue is surely not the version of Jet; it is the version of the
compiled sourcecode.

No? Yes?

TC
"SA" <~f***********@nspm.com> wrote in message
news:bp**********@ngspool-d02.news.aol.com...
A2000 mdes are able to be run currently in Access 2002 (Xp) and in Access 2003; they all use the Jet 4.0 engine....
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"Peter Russell" <ru***@127.0.0.1> wrote in message
news:me**********************@russellscott.btinter net.com...
wolftor previously wrote:

> 1) Is there a free runtime version of Access available that is more
> recent
> than the one for Access 2000?

No version of the Access runtime has ever been free.
If you are using a 'free' version then you are using an unlicensed
version.

> 2) If I create an application (MDE) in A2K, will it run on all later
> versions of Access?

Probably, if it doesn't include references for other products.
(All can only be 2002 and 2003 - who knows what will happen after that)
Regards

Peter Russell



Nov 12 '05 #12
TC
Thanks Steve, I didn't know that. So just to be sure: is it now >policy<
that an MDE created with or after A2k, will >definitely< run on all future
versions of Access? Or is that just what happens at present, with the
current versions > 97? Is there anything in the online help on that? (Sorry
to ask, but I do not have A2k+ available, at all, at present.)

TC
"SA" <~f***********@nspm.com> wrote in message
news:bp**********@ngspool-d02.news.aol.com...
TC:

If you've opened a copy of Access 2002 or 2003 lately you'll find that they know how to read A2000 formatted dbs, mdb, or mde. Heck you can even
reference an A2000 mde from an A2K2 mdb without problem.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"TC" <a@b.c.d> wrote in message news:1069030712.627435@teuthos...
But I believe the policy is, an MDE will not >necessarily< run on every
higher version of Access.

The issue is surely not the version of Jet; it is the version of the
compiled sourcecode.

No? Yes?

TC
"SA" <~f***********@nspm.com> wrote in message
news:bp**********@ngspool-d02.news.aol.com...
A2000 mdes are able to be run currently in Access 2002 (Xp) and in Access 2003; they all use the Jet 4.0 engine....
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"Peter Russell" <ru***@127.0.0.1> wrote in message
news:me**********************@russellscott.btinter net.com...
> wolftor previously wrote:
>
> > 1) Is there a free runtime version of Access available that is more > > recent
> > than the one for Access 2000?
>
> No version of the Access runtime has ever been free.
> If you are using a 'free' version then you are using an unlicensed
> version.
>
> > 2) If I create an application (MDE) in A2K, will it run on all later > > versions of Access?
>
> Probably, if it doesn't include references for other products.
> (All can only be 2002 and 2003 - who knows what will happen after that) >
> Regards
>
> Peter Russell



Nov 12 '05 #13
I'm relatively sure that neither Microsoft nor any other corporation would
make such an open-ended promise. Access 2002 and Access 2003, by default,
save in Access 2000 file-format, so can run it.

I was not, and am not, convinced that an MDE made with Access 2002/3 can be
run by an earlier version.

Larry Linson
Microsoft Access MVP

"TC" <a@b.c.d> wrote in message news:1069121262.704056@teuthos...
Thanks Steve, I didn't know that. So just to be sure: is it now >policy<
that an MDE created with or after A2k, will >definitely< run on all future
versions of Access? Or is that just what happens at present, with the
current versions > 97? Is there anything in the online help on that? (Sorry to ask, but I do not have A2k+ available, at all, at present.)

TC
"SA" <~f***********@nspm.com> wrote in message
news:bp**********@ngspool-d02.news.aol.com...
TC:

If you've opened a copy of Access 2002 or 2003 lately you'll find that

they
know how to read A2000 formatted dbs, mdb, or mde. Heck you can even
reference an A2000 mde from an A2K2 mdb without problem.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"TC" <a@b.c.d> wrote in message news:1069030712.627435@teuthos...
But I believe the policy is, an MDE will not >necessarily< run on every higher version of Access.

The issue is surely not the version of Jet; it is the version of the
compiled sourcecode.

No? Yes?

TC
"SA" <~f***********@nspm.com> wrote in message
news:bp**********@ngspool-d02.news.aol.com...
> A2000 mdes are able to be run currently in Access 2002 (Xp) and in

Access
> 2003; they all use the Jet 4.0 engine....
> --
> Steve Arbaugh
> ACG Soft
> http://ourworld.compuserve.com/homepages/attac-cg
>
> "Peter Russell" <ru***@127.0.0.1> wrote in message
> news:me**********************@russellscott.btinter net.com...
> > wolftor previously wrote:
> >
> > > 1) Is there a free runtime version of Access available that is more > > > recent
> > > than the one for Access 2000?
> >
> > No version of the Access runtime has ever been free.
> > If you are using a 'free' version then you are using an unlicensed
> > version.
> >
> > > 2) If I create an application (MDE) in A2K, will it run on all later > > > versions of Access?
> >
> > Probably, if it doesn't include references for other products.
> > (All can only be 2002 and 2003 - who knows what will happen after

that)
> >
> > Regards
> >
> > Peter Russell
>
>



Nov 12 '05 #14
TC
> I was not, and am not, convinced that an MDE made with Access 2002/3 can
be run by an earlier version.

Larry, it would clearly be unsafe to assume that an MDE from any version,
would run in any earlier version. The later version would have new
constructus, requiring new opcodes (or whatever) in the MDE interpreter.
Those opcodes would not be recognized by earlier versions. There's no future
in wondering whether later version MDEs will ever run in earlier versions.

The question is, will >earlier< versions always run in >later< versions?

Personally, I have never seen any good explanation of why they should not.
However, I recall from A97 help, a clear statement that MDEs >will not< run
in later versions.

I gather that now, an A2k MDE will run in AXP. But is that by chance, or
does it represent a change of policy, or is it that no relevant changes were
made between the two versions? No-one seems to be asking that question.

When I create a new build of my product, I include a seperate MDE for each
version of Access that it supports: currently A97, A2k and AXP. My
installation program checks the version of Access on the user's PC, &
installs the corresponding MDE.

If the new rule is that MDEs will >definitely< run on future versions of
Access, then clearly, I only need two MDEs - one for A97, another for all
versions thereafer. But if that is >not< the new rule - and it only happens
at present "by chance" - then I'll stick with having a seperate MDE per
version.

It surprises me that this doesn't seem to have raised any interest. I design
my product based on what I know (or think I know!) >for sure<, not on things
I notice which might just be coincidence, or random hapennings.

So I am looking for a definitive statement, from someone, as to whether
there has been a change of policy regading upwards-compatibility of MDEs.
There can only be three answers to that:

- Yes, they are guaranteed to be upwards compatible from A2k onwards
(barring "acts of god", of course);

- No, they are >NOT< garanteed to be upwards compatible at all; it just
happens that A2k ones will run on AXP, but no-one should jump to conclusions
from that; or,

- We neither know, nor care. (A strange response, IMO, for anyone who
distributes a professional product.)

Cheers,
TC
"Larry Linson" <bo*****@localhost.not> wrote in message
news:Eu******************@nwrddc02.gnilink.net...
I'm relatively sure that neither Microsoft nor any other corporation would
make such an open-ended promise. Access 2002 and Access 2003, by default,
save in Access 2000 file-format, so can run it.

I was not, and am not, convinced that an MDE made with Access 2002/3 can be run by an earlier version.

Larry Linson
Microsoft Access MVP

"TC" <a@b.c.d> wrote in message news:1069121262.704056@teuthos...
Thanks Steve, I didn't know that. So just to be sure: is it now >policy<
that an MDE created with or after A2k, will >definitely< run on all future
versions of Access? Or is that just what happens at present, with the
current versions > 97? Is there anything in the online help on that?

(Sorry
to ask, but I do not have A2k+ available, at all, at present.)

TC
"SA" <~f***********@nspm.com> wrote in message
news:bp**********@ngspool-d02.news.aol.com...
TC:

If you've opened a copy of Access 2002 or 2003 lately you'll find that

they
know how to read A2000 formatted dbs, mdb, or mde. Heck you can even
reference an A2000 mde from an A2K2 mdb without problem.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"TC" <a@b.c.d> wrote in message news:1069030712.627435@teuthos...
> But I believe the policy is, an MDE will not >necessarily< run on every > higher version of Access.
>
> The issue is surely not the version of Jet; it is the version of the
> compiled sourcecode.
>
> No? Yes?
>
> TC
>
>
> "SA" <~f***********@nspm.com> wrote in message
> news:bp**********@ngspool-d02.news.aol.com...
> > A2000 mdes are able to be run currently in Access 2002 (Xp) and in
Access
> > 2003; they all use the Jet 4.0 engine....
> > --
> > Steve Arbaugh
> > ACG Soft
> > http://ourworld.compuserve.com/homepages/attac-cg
> >
> > "Peter Russell" <ru***@127.0.0.1> wrote in message
> > news:me**********************@russellscott.btinter net.com...
> > > wolftor previously wrote:
> > >
> > > > 1) Is there a free runtime version of Access available that is more
> > > > recent
> > > > than the one for Access 2000?
> > >
> > > No version of the Access runtime has ever been free.
> > > If you are using a 'free' version then you are using an

unlicensed > > > version.
> > >
> > > > 2) If I create an application (MDE) in A2K, will it run on all

later
> > > > versions of Access?
> > >
> > > Probably, if it doesn't include references for other products.
> > > (All can only be 2002 and 2003 - who knows what will happen after that)
> > >
> > > Regards
> > >
> > > Peter Russell
> >
> >
>
>



Nov 12 '05 #15

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
2314
by: Dalan | last post by:
After reading and experiencing the phenomenon of installing MS Office 2000 on a system that already has MS Office 97, or for that matter just Access 97 Runtime, I saw the ugliness that ensues. If...
7
8822
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
11
6551
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on...
1
4607
by: Zen | last post by:
From http://support.microsoft.com/kb/828956/ "Note Microsoft does not support the use of multiple versions of Microsoft Office on a Terminal Server. Coexistence is not supported on versions...
5
2899
by: B1ackwater | last post by:
We've fooled around with Access a bit, but only using the single-user store-bought version. It seems to be a good database - versatile and infinitely programmable - and can apparently be used as a...
43
4196
by: James Stewart | last post by:
If I were to begin creating a fairly simple database, i.e. a datasheet that would include two related tables to create an encyclopedic style database and then create some fairly indepth forms to...
8
2728
by: AppleBag | last post by:
I just looked in the folder that contains my .NET framework installations, and I have versions 1.0,1.1 and 2.0. Do I need the 1 series since I have version 2.0? Seems like it might just be a...
28
2033
by: larpup | last post by:
I have computers setup with A97 runtime with mde's. Work perfectly. I've written an app in 2003 and purchased the Developer extensions. When I load A2003 runtime with my app on a computer that...
16
11036
by: Neil | last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text feature does not support: a) full text justification; b) programmatic manipulation. I was hoping that someone might...
0
7111
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7376
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7031
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5623
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4702
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3191
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3179
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1542
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
760
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.