Re: Access 2003 and Access 2007 on same machine



Hi,

"Tom van Stiphout" <no.spam.tom7744@xxxxxxx> schrieb im Newsbeitrag
news:bi5ub3l3l09k56o4ccqoi32sl7tunie76e@xxxxxxxxxx
On Sun, 12 Aug 2007 06:16:11 -0700, Dennis <druppert@xxxxxxxxxxxxxx>
wrote:
Personally I do all my development work in A2007 (using MDB or ADP
version proscribed by client) switching back to older versions only
for testing and final build. There is a small risk I would use
features that are not yet available in that older version, but that is
very rare and easily fixed.

Ok, why not.
But I would do at least a DECOMPILE in the end and a new compile under A2003
before deploying it. I had several problems in the past with databases
developed under A2003 when opening in A2000. That usually happend for
databases with much code and much former changes in the VBA project.Often
the kind of errors were related to form events that didn't work. After
decompiling everthing worked fine.
Another point are the new system tables (e.g. for navigation pane) that are
written to the database under A2007 which are completely unusefull under
A2003. I'd delete them before deploing.
And there are many new properties for database objects and the database
itself which reside in it. I'm not that sure of cases where they could
disturb. (A 2003 mdb created new under A2007 has 180 kB, in A2003 it has 136
kB!)

Ciao, Sascha


.



Relevant Pages

  • Re: Different versions of MS-ACCESS
    ... I always recommend that you either develop, or test extra thoroughly, on the ... Microsoft Office Access MVP ... the development work, but I will still need to move these objects back ... to the ACCESS 97 database. ...
    (comp.databases.ms-access)
  • Re: Access hanging, corrupting, getting me worried
    ... are you using a laptop PC for your development work? ... Have you tried doing development work on a different PC at work? ... Is this a single-user database located on one PC? ... crash on importing some object, there doesn't appear to be any logic to which one. ...
    (microsoft.public.access.forms)
  • Re: Copying a linked table
    ... into a replica table that is local on my computer? ... development work at home where I can not access the main table. ... Navigate to the database that contains the actual back end table. ...
    (comp.databases.ms-access)
  • Re: Question about setting up Front End/Back End...
    ... development work, yes. ... each book's perspective is different and combinations of the books helps me ... "Lisa" wrote in message ... >> There is a database splitter utility built into ACCESS that will do the ...
    (microsoft.public.access.gettingstarted)
  • Re: Opinions needed about the best "Middleware suite" kbmMW vs. RODA
    ... kbmMW supports cross db in such way that all you need to do in your application is to set one property to switch to ... What one have to concentrate about is minimizing the amount of data moved from the app server to the client. ... C/S setup's usually have a quite active chatter going on between the client and the database, ...
    (borland.public.delphi.thirdpartytools.general)