Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Replicated database with diff. versions of Acces?

Discussion in 'Information Technology' started by MarioFromBelgium, Jul 28, 2006.

  1. MarioFromBelgium

    MarioFromBelgium
    Expand Collapse
    Guest

    Hi,

    does anybody know of possible problems we might run into if we update our
    client-computers from Acces 2000 to Acces 2003, with regrards to the fact
    that every client has a few databases (developed under A2000) that have to be
    synchronised with the server-version?

    We can't update all clients at once so there will be a period in which we
    have different versions of acces. This means the server-version will recieve
    synchronisations from instances of the same database but from different
    versions of ACCES!!
     
  2. Loading...

    Similar Threads Forum Date
    USA NSA has massive database of Americans' phone calls (USA Today 5.11.2006) Breaking News Jun 11, 2013
    Some database errors while navigating SPN forums Announcements Dec 29, 2004

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Hopefully all your applications are split into front-ends (containing the
    queries, forms, reports, macros and modules), linked to back-ends
    (containing the tables and relationships). Only data (eg: the back-ends)
    should be replicated: replication is not intended for application components
    (the front-ends).

    With that understanding, there's no reason why all your back-ends can't be
    in the same version: Access 2003 will work quite happily with an Access 2000
    back-end (heck, it'll work fine with an Access 95 back-end!)

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "MarioFromBelgium" <MarioFromBelgium@discussions.microsoft.com> wrote in
    message news:2F163F47-27AA-4BD4-BC00-AEAED423F635@microsoft.com...
    > Hi,
    >
    > does anybody know of possible problems we might run into if we update our
    > client-computers from Acces 2000 to Acces 2003, with regrards to the fact
    > that every client has a few databases (developed under A2000) that have to

    be
    > synchronised with the server-version?
    >
    > We can't update all clients at once so there will be a period in which we
    > have different versions of acces. This means the server-version will

    recieve
    > synchronisations from instances of the same database but from different
    > versions of ACCES!!
     
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    MarioFromBelgium wrote:
    > Hi,
    >
    > does anybody know of possible problems we might run into if we update
    > our client-computers from Acces 2000 to Acces 2003, with regrards to
    > the fact that every client has a few databases (developed under
    > A2000) that have to be synchronised with the server-version?
    >
    > We can't update all clients at once so there will be a period in
    > which we have different versions of acces. This means the
    > server-version will recieve synchronisations from instances of the
    > same database but from different versions of ACCES!!


    I don't believe there is a problem, as long as, all the versions of
    Access support the file format version.

    --
    Joseph Meehan

    Dia duit
     
  5. dbahooker@hotmail.com

    dbahooker@hotmail.com
    Expand Collapse
    Guest

    WORK FINE?

    Access MDB files don't WORK FINE without replication.

    screw MDB and don't listen to these MDB wimps.
    upgrade your app / db to sql server and utilize access data projects.

    they are 10,000 times more powerful and reliable than silly obsolete
    mdb files
     
  6. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    MarioFromBelgium <MarioFromBelgium@discussions.microsoft.com> wrote:

    >does anybody know of possible problems we might run into if we update our
    >client-computers from Acces 2000 to Acces 2003, with regrards to the fact
    >that every client has a few databases (developed under A2000) that have to be
    >synchronised with the server-version?


    Your subject implies that the front ends are replicated. If so
    that's not a good idea. Replication is meant only for tables and
    records.

    Michael Kaplan, www.trigeminal.com, has stated that replicating non
    table objects is a bad idea and can lead to corruption and many
    problems.

    I specifically created the Auto FE Updater utility so that I could
    make changes to the FE MDE as often as I wanted and be quite confident
    that the next time someone went to run the app that it would pull in
    the latest version. For more info on the errors or the Auto FE
    Updater utility see the free Auto FE Updater utility at
    http://www.granite.ab.ca/access/autofe.htm at my website to keep the
    FE on each PC up to date.

    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.granite.ab.ca/accsmstr.htm
     

Share This Page