Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    New England (Connecticut)
    Posts
    200
    Thanks
    1
    Thanked 0 Times in 0 Posts

    distribution (2k on NT and Windows2k)

    I have an application which due to the nature of the business requires updating to reports and calcualtions depending on contract structure on a fairly routine basis. I update about 1 to 2 times a month. I tried to distribute the front end via a .bat file through email. I used one for the NT structure and one for the Windows 2k structure. I tried to make the .bat file copy the front end from the network to the users desktop automatically. I got mised results. Depending on the permissions of the users it was successfull only sometimes. It seems that on some of the machines (so far the NT machines), the .bat file did not run correctly. Is there an easier way to distribute this front end? Keep in mind, for security reasons, our management has configured outlook to strip off any attachments with the .mdb extension. So directly emailing the front end is not an option. Not to mention it is about 7 megs big. Thanks for any help anyone can give me on this issue.
    Kevin

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: distribution (2k on NT and Windows2k)

    How many users is your front-end being deployed to? One technique is to simply have something in the login script that downloads the front-end if it has changed. If you have more complex needs, FMS has a product that will do the trick for you, and we also have one you can read about on our website. By the way, if your management is worried about sending .mdb files as attachments, they should worry lots more about .bat files. One of those can wipe your hard drive in seconds.
    Wendell

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    New England (Connecticut)
    Posts
    200
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: distribution (2k on NT and Windows2k)

    Hi, thanks,
    there are about 25 users total. The log on script sounds interesting. Management has also scrubbed .bat files as an attachment, but i learned that a link to one will work just fine. I would also like to read about the process on the WEB site. Is that a matter of just searching on the topic?

    THanks
    Kevin
    Kevin

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: distribution (2k on NT and Windows2k)

    Wendell's company 'Access Experts' has a tool for deploying databases: DBLauncher.

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: distribution (2k on NT and Windows2k)

    In addition to Hans' comments, the FMS product Access Startup is available. It is a more sophisticated product in that it lets you start whatever version of Access is required for a given database. Our product is more limited, but will also update such things as .mdw files, DLLs and OCX ActiveX controls. I don't know of a good web resource to read about the problem in a more general way - ours grew out of the need to deploy complex front-ends to from 80 to 200 workstations without making everyone logout of the database at once. Your batch file should be able to do much the same thing, and by putting it in the login script, it would update whenever it detected a newer version - we typically deploy an MDE version of the front-end. Hope this helps - if you specific questions I'll try to answer them as best I can.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •