Post reply

Views not executing in access project

  • September 19, 2008 at 3:02 am

    #874062

    Multiple users of one adp is not a good idea anyway - performance will be greatly reduced and you will have lots of concurrency problems like the ones you are experiencing.

    If the users are not developers, build the project as a compiled ade project and give each user a copy of this to be held locally on their PC.

    To prevent users working with old versions of a frontend, build a version number into the code and hold the current version number of the front end in a table in the backend database. In the startup macro or screen, compare the FE version with the BE version, and if they don't match, prevent the application from running.

    I use code like this:

    Option Explicit

    Public Const CurrentVersion = "5.36c"

    Public Function CheckVersion() As Boolean

    On Error GoTo err_handler

    Dim dbVer As String

    dbVer = Nz(DLookup("CurrentVersion", "tblSystemData"), "")

    If dbVer <> CurrentVersion Then

    MsgBox "Invalid Program Version - please check your email or contact Support" & vbCrLf & "FE v " & CurrentVersion & vbCrLf & "BE v " & dbVer, vbCritical + vbOKOnly, "Invalid Version"

    Application.Quit

    Else

    CheckVersion = True

    End If

    exit_handler:

    Exit Function

    err_handler:

    MsgBox "(" & Err.Number & ")" _

    & vbNewLine & vbNewLine & Err.Description, vbOKOnly + vbInformation, "Version Number Error"

    Resume exit_handler

    End Function

    I roll new versions out using a simple batch file - I send a link to the batch file to all users, then change the current version number in the back end - this stops the old versions working, and they have to click on the link in the email to get the new version installed - these are held in a directory hierarchy on the server, as is the batch file.

    The batch files I use are like this:

    @Echo off

    Echo Now Installing GE Money v2.05

    if Exist "C:\Access Systems\GEMoney.ade" copy "\\audit4\ciapps\Access Systems\GE Money\v2.05\GEMoney.ade" "C:\Access Systems\GEMoney.ade" >nul:

    Echo v2.05 Installation Completed

    pause

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply