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

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)
     
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