creating automatic VBA updates

Posted on 2007-08-06
Last Modified: 2013-11-27
I am currently in the process of design a custom database solution for one of our customers, and i have come across quite a problem.
we were going to design the solution in Access VBA with SQL server and we were wondering how it would be possible for us to update all our 30 clients with the new update.
We currently use Filemaker server 9 and use a shared file and this allows us to update this one file and then everyone will instantly have the new update, but VBA allows us to do more and this is why we went for VBA.

i know you have have version numbers and build numbers but is there a way of automatically updating the users
Question by:admoortown
    LVL 77

    Expert Comment

    This is one of several similar utilities available on the net.

    Author Comment

    Thanks peter, this seems for an older verison - we will be running XP Pro and Vista business.  our solutions will be developer run times as well.
    LVL 77

    Accepted Solution

    The latest version is for Vista. (See version history)  Runtime/full version is not relevant AFAIK.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
    CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now