Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

App deployment

Discussion in 'Information Technology' started by John, Nov 9, 2005.

Tags:
  1. John

    John
    Expand Collapse
    Guest

    Hi

    I have an access frontend/backend app which I update frequently to add new
    features. At the moment, on a network with large number of client PCs I need
    to copy the mde file individually on all pcs and create icon etc. Is there a
    easier way to deploy an access app to multiple pcs in a network?

    Thanks

    Regards
     
  2. Loading...


  3. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    There is a great "auto update" that updates the front end for you here:


    "John" <John@nospam.infovis.co.uk> wrote in message
    news:uCreXoN5FHA.692@TK2MSFTNGP11.phx.gbl...
    > Hi
    >
    > I have an access frontend/backend app which I update frequently to add new
    > features. At the moment, on a network with large number of client PCs I
    > need to copy the mde file individually on all pcs and create icon etc. Is
    > there a easier way to deploy an access app to multiple pcs in a network?
    >
    > Thanks
    >
    > Regards
    >
    >
    >
    >
     
  4. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

  5. Tony Toews

    Tony Toews
    Expand Collapse
    Guest


    >use ADP it is a lot easier to deal with.


    ADPs have their good points and their bad poitns.

    >i mean-- you dont have to distro anything when you change a query.
    >because all the tables and queries are stored in one place.


    You've never responded my previous postings on this topic.

    It is very seldom that I just change queries. I'd also be updating forms, reports
    and VBA code as well. So you'd still need to distribute new FEs be they MDBs or
    ADPS.

    >and the database is about 3 times faster if you just bite the bullet
    >and learn ADP.


    Database or development speed?

    >i mean.. MDB is a disease
    >aren't you tired of
    >
    >a) queries crapping out


    Really? The few times I've had troubles with queries I've figured out work arounds.
    And these were very complex nested queries so nothing would've surprised me.

    >b) refreshing linking, updating


    Updating is rather a broad topic. But as far as refreshing and linking goes what
    happens when you change the SQL Server database from a test to live environment? You
    still ahve the same issues.

    >c) DSNs


    Who uses DSNs? Go DSN less

    Using DSN-Less Connections
    http://www.accessmvp.com/djsteele/DSNLessLinks.html
    ODBC DSN-Less Connection Tutorial Part I
    http://www.amazecreations.com/datafast/GetFile.aspx?file=ODBCTutor01.htm&Article=true
    HOWTO: Use "DSN-Less" ODBC Connections with RDO and DAO
    http://support.microsoft.com/?id=147875
    ODBC DSN Less
    http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm

    >d) versioning queries


    Repeat. It is very seldom that I just change queries. I'd also be updating forms,
    reports and VBA code as well. So you'd still need to distribute new FEs be they MDBs
    or ADPS.

    >but i mean-- the root of the problem is that MDB is a crap architecture.


    Rubbish.

    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
     
  6. Tony Toews

    Tony Toews
    Expand Collapse
    Guest


    >uh i can't go DSN less.. you see.. it's slower than a DSN right??


    Why is it slower? News to me.

    >MDB IS A CR(P ARCHITECTURE.
    >IT DOESNT SCALE. IT DOESN"T WORK WITH A DOZEN USERS.


    Rubbish. I have clients with 25 users on it with no problems.

    >the point about Access queries-- you shoulnd't NEED workarounds.
    >
    >Access ADP queries dont require workarounds. it is a much better query
    >engine; i mean.. WOW


    I agree that queries have troubles is not good. But I've had so few of them it
    hasn't been a problem for me.

    >and just for the record; it's easy to have ONE connection in an ADP
    >that points to test or prod or dev.


    Ok, so that's a bit easier than relinking tables. Big deal.

    >and dev gets versioned with every major release
    >
    >i sure dont have versioning problems with SQL..


    What versioning problems are you talking about here?

    >and i can keep track of
    >changes to data with TRIGGERS (if i need to)


    Sure, that's a minor point in favour of using SQL Server. Not a big deal to most
    people.

    >MDB is just a waste of time; you must smoke crack kid


    Wrong. MDBs suit the vast majority of users just fine.

    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
     
  7. Tony Toews

    Tony Toews
    Expand Collapse
    Guest


    >im talking about linking, refreshing, DSNs.
    >
    >im talking about changing Sql Passthroughs in order to fire a sproc.
    >
    >it's just too complex, MDB against SQL Server. and it's not as
    >powerful.


    Please also respond to the other points I mention. Feel free to be quite specific.

    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
     
  8. Alex Dybenko

    Alex Dybenko
    Expand Collapse
    Guest

    Hi,

    >>it's just too complex, MDB against SQL Server. and it's not as
    >>powerful.


    IMHO - this is only a first impression, at the end you will find that MDB
    with SQL server is more efficient to deal with.

    BTW, Tony - I only see your replies, and no OP posts - any idea why this?

    --
    Alex Dybenko (MVP)
    http://alexdyb.blogspot.com
    http://www.PointLtd.com



    "Tony Toews" <ttoews@telusplanet.net> wrote in message
    news:36o7n1lrtkb07kaj55pqs6s5c9favq742s@4ax.com...
    >
    >>im talking about linking, refreshing, DSNs.
    >>
    >>im talking about changing Sql Passthroughs in order to fire a sproc.
    >>
    >>it's just too complex, MDB against SQL Server. and it's not as
    >>powerful.

    >
    > Please also respond to the other points I mention. Feel free to be quite
    > specific.
    >
    > 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
     
  9. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Tony's trying to get answers from Aaron Kempf, who appears to have succeeded
    in getting himself banned from the msnews.microsoft.com server. I suspect
    Tony gets his newsgroup feed from a different server.

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


    "Alex Dybenko" <alexdyb@PLEASE.cemi.NO.rssi.SPAM.ru> wrote in message
    news:edegzzn5FHA.3416@TK2MSFTNGP15.phx.gbl...
    >
    > BTW, Tony - I only see your replies, and no OP posts - any idea why this?
    >
    > --
    > Alex Dybenko (MVP)
    > http://alexdyb.blogspot.com
    > http://www.PointLtd.com
     
  10. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote:

    >I suspect
    >Tony gets his newsgroup feed from a different server.


    Correct.

    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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page