Can Access 2007 develop a 2003 app to run on access 2003 runtime

Can Access 2007 develop a 2003 app to run on access 2003 runtime

Post by Um9iR01pbG » Mon, 25 Jun 2007 04:20:00


Need to work on an existing 2003 access mdb with 2007 and produce a
application MDE that runs on 2003 runtime.

I have done some work on it and it seems to function ok although I could not
see an obvious way to produce an MDE which is also a requirement.

The MDE issue can be managed. However, I'd like to know if there are
limtations before I get started.

Thanks in advance...
--
RobGMiller
 
 
 

Can Access 2007 develop a 2003 app to run on access 2003 runtime

Post by MV » Mon, 25 Jun 2007 04:56:27

You cannot create an .mde in 2003 format from ACCESS 2007. Only ACCESS 2003
can do that. However, you can open/edit/modify a 2003 .mdb using ACCESS
2007.

--

Ken Snell
<MS ACCESS MVP>

 
 
 

Can Access 2007 develop a 2003 app to run on access 2003 runtime

Post by Jeff Conra » Mon, 25 Jun 2007 06:20:43

Slight correction there Ken.

You *can* actually create a 2003 MDE in Access 2007 if you use the 2003 format.

....however, even Access 2003 won't be able to run it, only 2007.
;-)

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.yqcomputer.com/
Access 2007 Info: http://www.yqcomputer.com/

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.yqcomputer.com/
----------
 
 
 

Can Access 2007 develop a 2003 app to run on access 2003 runtime

Post by Arno » Mon, 25 Jun 2007 06:37:04


Then the behavior of A2007 regarding mde's is different from all earlier versions ??
Mde's could only be created from, or with, the specific version.

Seems a bit odd to me to be able to create a 2003 mde, that *not* seems to *be* a 2003 mde.
==> If it was a 2003 mde, Access 2003 would be able to run it, no ??

Seem like a mis-feature to me... or am I missing something ??

Arno R
 
 
 

Can Access 2007 develop a 2003 app to run on access 2003 runtime

Post by MV » Mon, 25 Jun 2007 08:31:04

Thanks; haven't become completely conversant in 2007 yet.... < s, >

--

Ken Snell
<MS ACCESS MVP>
 
 
 

Can Access 2007 develop a 2003 app to run on access 2003 runtime

Post by Jeff Conra » Mon, 25 Jun 2007 09:34:12


Hi Arno,

Comments in-line...


That's correct, however, you have to remember that this is the first version to support two
*radically* different file formats.


You would think perhaps ir should, but that is not the case.


No, not a mis-feature at all. Allow me to quote some comments from a work colleague:

"I believe this mostly has to do with the compiled version of the Access type library. For example,
if you create the MDE with Access 2007, the VBA project contains a reference to the Access 12.0
object model. Since object models tend to change from version to version, running code compiled in a
future version in a previous version will likely lead to a crash as functions are called that don't
exist in the previous versions."

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.yqcomputer.com/
Access 2007 Info: http://www.yqcomputer.com/

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.yqcomputer.com/
----------
 
 
 

Can Access 2007 develop a 2003 app to run on access 2003 runtime

Post by Um9iR01pbG » Mon, 25 Jun 2007 11:07:00

Thanks for all your comments.

The MDE is really not an issue. I will create it with 2003. I am just trying
to confirm, if possible, that a 2003 app modified in 2007 has no known issues
when converting it to 2003 MDE with Access 2003.


--
RobGMiller
 
 
 

Can Access 2007 develop a 2003 app to run on access 2003 runtime

Post by Rick Brand » Mon, 25 Jun 2007 20:29:09


At this point we can't even confirm that an app developed in Access 2007 has no
known issues when running it with Access 2007 :-)

As a general rule it is better to develop in the same (or older) version that
your users will use. Going the other direction it is too easy to accidentally
slip in a feature during development that won't work in the older versions.
That can happen despite the file version you use.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
 
 
 

Can Access 2007 develop a 2003 app to run on access 2003 runtime

Post by Arno » Mon, 25 Jun 2007 22:10:47


Hi Jeff,

Thanks for the comments, this means that the following is true... ??
"When there are no 'not-yet-existing-in-older-version-functions' used then there are no problems running the mde in A2003."

But I am afraid you are going to tell me that this is not true... ;-)

Arno R
 
 
 

Can Access 2007 develop a 2003 app to run on access 2003 runtime

Post by Jeff Conra » Tue, 26 Jun 2007 05:13:51


Hi Arno,



You're correct, the MDE file compiled in 2007 simply won't run in Access 2003 no matter if you use
only 2003 and pre-2003 functions.

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.yqcomputer.com/
Access 2007 Info: http://www.yqcomputer.com/

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at:
http://www.yqcomputer.com/
----------
 
 
 

Can Access 2007 develop a 2003 app to run on access 2003 runtime

Post by StopThisAd » Tue, 26 Jun 2007 07:09:39


We are talking about a A2003 mde, right ???
We are talking about A2007 that has the 'feature' of being able to compile a A2003 mde, right ???
And you say that it simply won't run ....
Then....what's the use ???
And you say this is not a mis-feature at all ??

Well, I lost you on this Jeff...
I am not starting a dispute about this, but let's call it a "feature that we can not use" ??

Arno R
 
 
 

Can Access 2007 develop a 2003 app to run on access 2003 runtime

Post by Jeff Conra » Tue, 26 Jun 2007 10:26:46

Hi Arno,


That's correct.


That's correct.


I'm saying it won't run in versions *previous* to Access 2007.
It will still run just fine in Access 2007.


Actually no, I didn't say it was mis-feature at all (if you re-read my comments).
I'd call it more an interesting quirk and nothing more.


No, I'm following along just fine.


Just a different way of looking at things. No previous version of Access has ever been able to
create an MDE that will run in a previous version; Access 2007 is no different in that regard. This
latest version just has an interesting quirk to be able to create two types of compiled files - MDE
and ACCDE.

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.yqcomputer.com/
Access 2007 Info: http://www.yqcomputer.com/

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at:
http://www.yqcomputer.com/
----------
 
 
 

Can Access 2007 develop a 2003 app to run on access 2003 runtime

Post by Tony Toews » Tue, 26 Jun 2007 13:13:06


We can't guarantee anything. However I work in A2000 format MDBs in A2003. And then
create the MDE in A2000 and it works fine.

However I would think that it would work. You might need to do a decompile in A2003
to clean things up occasionaly. You might have to do a Save As to save the MDB in
A2000 format to really clean things up but there aren't any significant features in
A2002/2003. Hmm, other than the printer object which I've never used.

Worst case scenario is that you might have to do a SaveAsText for all your forms,
reports and modules and import them again.

Corrupt Objects within a Corrupt Microsoft Access MDB
http://www.yqcomputer.com/

The little documented SaveAsText and LoadFromText may help if an object is corrupted
or otherwise behaving weirdly.
At the debug/immediate window type:
Application.SaveAsText acForm,"MyForm","c:\form.txt
You can load the file into a new MDB.
Application.LoadFromText acForm,"MyForm","c:\from.txt"

Sample code at http://www.yqcomputer.com/
in an MDB.

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.yqcomputer.com/
Tony's Microsoft Access Blog - http://www.yqcomputer.com/
 
 
 

Can Access 2007 develop a 2003 app to run on access 2003 runtime

Post by Arno » Tue, 26 Jun 2007 15:16:40


Thanks Jeff.

BTW: Sorry that I posted my previous question with the wrong account ...
Busy these days switching accounts ...

Arno R
 
 
 

Can Access 2007 develop a 2003 app to run on access 2003 runtime

Post by Jeff Conra » Tue, 26 Jun 2007 15:32:25


No problem.
;-)

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.yqcomputer.com/
Access 2007 Info: http://www.yqcomputer.com/

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at:
http://www.yqcomputer.com/
----------