Welcome to SPN

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

Sign Up Now!

Open Acc2K Database Exclusively

Discussion in 'Information Technology' started by Tony, Jul 28, 2006.

  1. Tony

    Tony
    Expand Collapse
    Guest

    Hi All,

    I have an Access database that we're using to pull information from a
    Progress database. We pull the data in, massage it, and the results end up
    being printed on employee's checks. Two users use the database for this
    function and a third user does straightforward data entry. The process of
    getting the data on the checks is complicated, involving looping through a
    recordset and printing a TIF image of the output. Because it's complicated
    and deals with payroll, I'd like to give the users that run the payroll
    function exclusive access when they open the database.

    Currently I'm testing using the /excl switch in a shortcut and am using code
    found here http://support.microsoft.com/?kbid=210359 to see if the database
    is opening exclusively. In addition to this test, I have a second machine
    where I log in as a different user and attempt to open the database. So
    far, I've had no luck. The code from MS's site always tells me that the
    database is not being opened exclusively and I can always open the database
    from the second machine. The shortcuts I've set up on both machines are set
    up like this:

    TARGET: \\pathToDatabaseFolder\database.mdb /excl
    START IN: \\pathToDatabaseFolder

    The path is the UNC path and the clients are running Access2K on a Windows
    network.

    Can anyone point out what I'm missing?

    Thanks & Ciao,

    Tony
     
  2. Loading...


  3. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "Tony" <|toxendine|@hoopercorp.com> wrote in message
    news:%23zfU5TYsGHA.1580@TK2MSFTNGP05.phx.gbl
    > Hi All,
    >
    > I have an Access database that we're using to pull information from a
    > Progress database. We pull the data in, massage it, and the results
    > end up being printed on employee's checks. Two users use the
    > database for this function and a third user does straightforward data
    > entry. The process of getting the data on the checks is complicated,
    > involving looping through a recordset and printing a TIF image of the
    > output. Because it's complicated and deals with payroll, I'd like to
    > give the users that run the payroll function exclusive access when
    > they open the database.
    >
    > Currently I'm testing using the /excl switch in a shortcut and am
    > using code found here http://support.microsoft.com/?kbid=210359 to
    > see if the database is opening exclusively. In addition to this
    > test, I have a second machine where I log in as a different user and
    > attempt to open the database. So far, I've had no luck. The code
    > from MS's site always tells me that the database is not being opened
    > exclusively and I can always open the database from the second
    > machine. The shortcuts I've set up on both machines are set up like
    > this:
    >
    > TARGET: \\pathToDatabaseFolder\database.mdb /excl
    > START IN: \\pathToDatabaseFolder
    >
    > The path is the UNC path and the clients are running Access2K on a
    > Windows network.
    >
    > Can anyone point out what I'm missing?


    I'm not sure, but I think if you want to supply command-line switches
    you have to include the path to the msacess.exe executable in your
    target. Like this:

    "C:\Program Files\Microsoft Office XP\Office10\MSACCESS.EXE"
    "\\pathToDatabaseFolder\database.mdb" /excl

    Be aware that it's not such good idea to open an Access database over
    the network. It works, but it's corruption-prone. Better to use a
    split front-end/back-end arrangement.

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     
  4. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "Dirk Goldgar" <dg@NOdataSPAMgnostics.com> wrote in message
    news:O$NS9%23YsGHA.4420@TK2MSFTNGP04.phx.gbl
    >
    > "C:\Program Files\Microsoft Office XP\Office10\MSACCESS.EXE"
    > "\\pathToDatabaseFolder\database.mdb" /excl


    Note that your own path to the Access executable will be different.

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     

Share This Page