Re: Comparetive study DAO v/s JRO

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jonathan Parminter (JonathanParminter_at_discussions.microsoft.com)
Date: 01/20/05

  • Next message: Douglas J. Steele: "Re: Comparetive study DAO v/s JRO" 
    Date: Thu, 20 Jan 2005 11:33:07 -0800

    Hi Douglas, I have split a database. Occassionally I add enhancements to the
    database which means that I have the hassle of distributing the changed front
    end to the various uses. I am considering converting the front end (forms,
    reports, queries, etc.) to a design master that is replicated for each user.
    The aim is for users to synchronize with the design master when changes are
    made.

    Are you saying that the above is a 'bad' idea?

    "Douglas J. Steele" wrote:

    > You're not trying to replicate front-end objects, are you? (forms, reports,
    > queries, etc.)
    >
    > Replication is only intended for data.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    >
    > "Ritesh" <ritesh@hotmail.com> wrote in message
    > news:uTNv9$L8EHA.2124@TK2MSFTNGP14.phx.gbl...
    > > Hi! All,
    > >
    > > I have used JRO to replicate and Synchronize.
    > >
    > > I thought its better than DAO,
    > >
    > > But, I made a wrong decision, i think, as jro always wants database in
    > > exclusive mode.....
    > >
    > > In practical application scenario its not always possible.
    > >
    > > Hence, I think that DAO might be the better option for me.
    > >
    > > Anybody having any idea/experience of both JRO DAO, or any website where I
    > > can find Comparative study of JRO v/s DAO.....?
    > >
    > > I need to have a comparative study or pros and cons of both JRO and DAO.
    > >
    > > Any help?
    > >
    > > Thanks,
    > > Ritesh.
    > >
    > >
    >
    >
    >

  • Next message: Douglas J. Steele: "Re: Comparetive study DAO v/s JRO"

    Relevant Pages

    • Re: error message on ISAM
      ... I went back to DAO where I used the code for ... > ¤ Paul, ... > ¤ concerning compacting a database. ... I also think I got this jro code from you ...
      (microsoft.public.vb.database)
    • Comparetive study DAO v/s JRO
      ... I have used JRO to replicate and Synchronize. ... But, I made a wrong decision, i think, as jro always wants database in ... I think that DAO might be the better option for me. ... I need to have a comparative study or pros and cons of both JRO and DAO. ...
      (microsoft.public.access.replication)
    • Re: Import Text with existing schema.ini file utility
      ... the database engine looks for schema.ini. ... As far as I know it's not possible to specify schema.ini in SQL; ... DAO is specifically designed to work with the Jet ... >> oDB.Execute strSQL ...
      (microsoft.public.access.modulesdaovba)
    • Re: Run action query in back-end from front-end database
      ... whatnot in the back end database. ... The queries are housed in the back end ... The reason I have the upload tables in the back end is that it will be on ... Rick's code uses DAO, and Access 2000 doesn't have a reference set by ...
      (microsoft.public.access.externaldata)
    • Re: Dao350.dll unsupported under Windows 7
      ... Jet 4.0 is that we have many customers now using our app with DAO 3.51 ... standard user account in Windows to ensure none of the Sandbox ... tried one of our menu commands: Compact Database. ... CloseDB, didn't close the db and left an ldb file lying around. ...
      (microsoft.public.vb.general.discussion)