Welcome to SPN

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

Sign Up Now!

Access2000 Fails to Open as Multiuser Database

Discussion in 'Information Technology' started by ortaias@hotmail.com, Jul 28, 2006.

  1. ortaias@hotmail.com

    ortaias@hotmail.com
    Expand Collapse
    Guest

    The Access2000 database is on a remote server. Our office has a mixture
    of WindowsXP and Windows2000 as the operating system. We are using
    Novell Netware for the office network. I am wondering if the Novell
    Network is "confusing" Access???

    The check box option to open Access2000 as a multiuser database is
    checked. Also "No locks" is checked. When the database is opened we
    get the "LBD" file with "access.lockfile.9". When I look at this file,
    I see my name and the word "Admin", which seems normal. However, if
    another user attempts to open the database, they can't and get a
    message that another user is using the program.

    According to Micorsoft, Access must be in a shared directory. Since
    everyone can read/write to the directory it appears "shared".
    Nevertheless, is it possible that the Novell Network has a conflict
    which presents Access from being shared?
     
  2. Loading...

    Similar Threads Forum Date
    1984 Sikh Genocide 1984: CBI fails to respond to plea against clean chit to Jagdish Tytler History of Sikhism Mar 21, 2012
    India Ministers on leave, police fails to solve murder cases Breaking News Feb 21, 2012
    India SGPC Fails to Convince Golden Temple Look-alike to Change Structure Breaking News Jul 12, 2011
    India Indian Government Fails to Resolve Turban Issue with France Breaking News Feb 19, 2011
    India BSNL fails to honour Rs 392 cheque Breaking News Jan 7, 2011

  3. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    What do you mean by "remote server"? Is it a server on your network or
    somewhere more distance like on a WAN in another building, city, or state?

    Novell use to have record locking problems with Access back in the day;
    however, that shouldn't be a problem anymore. Anyway that was record locking
    and not file locking.

    You say read/write. How about create and delete? Need them too.
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "ortaias@hotmail.com" wrote:

    > The Access2000 database is on a remote server. Our office has a mixture
    > of WindowsXP and Windows2000 as the operating system. We are using
    > Novell Netware for the office network. I am wondering if the Novell
    > Network is "confusing" Access???
    >
    > The check box option to open Access2000 as a multiuser database is
    > checked. Also "No locks" is checked. When the database is opened we
    > get the "LBD" file with "access.lockfile.9". When I look at this file,
    > I see my name and the word "Admin", which seems normal. However, if
    > another user attempts to open the database, they can't and get a
    > message that another user is using the program.
    >
    > According to Micorsoft, Access must be in a shared directory. Since
    > everyone can read/write to the directory it appears "shared".
    > Nevertheless, is it possible that the Novell Network has a conflict
    > which presents Access from being shared?
    >
    >
     
  4. ortaias@hotmail.com

    ortaias@hotmail.com
    Expand Collapse
    Guest

    The server is a local network connection.

    Users have create/delete permissions on the networked directory.

    I brougnt my Flash USB device to work, I will copy the database to my
    home network tonight and see if I have multiuser access.
     
  5. ortaias@hotmail.com

    ortaias@hotmail.com
    Expand Collapse
    Guest

    I took the database home and had limited sharing success. First, the
    folder that access is in must be fully labeled as shared, read/write
    privileges by themselves don't seem to allow multiuser access. Second,
    after closing the database, I would get a "can't find" the database
    message from windows explorer even though the file was visible.
     
  6. ortaias@hotmail.com

    ortaias@hotmail.com
    Expand Collapse
    Guest

    I took the database home and had limited sharing success. First, the
    folder that access is in must be fully labeled as shared, read/write
    privileges by themselves don't seem to allow multiuser access. Second,
    after closing the database, I would get a "can't find" the database
    message from windows explorer even though the file was visible.
     
  7. ortaias@hotmail.com

    ortaias@hotmail.com
    Expand Collapse
    Guest

    The following code derived from "Programming Microsoft Access Version
    2002" By Rick Dobson has partially resolved the issue of getting the
    database open as a multiuser database.
    -------------------------------------------------------------------------------------------------------------------
    str1 = "Provider=microsoft.jet.oledb.4.0;" & "data source=P:\Federal
    Consistency\consistency.mdb"
    Rem -------------------------------------------------------------
    Rem initialize dataset
    Set cnn1 = New ADODB.Connection
    Set rst1 = New ADODB.Recordset
    cnn1.Open str1
    rst1.CursorType = adOpenKeyset
    rst1.LockType = adLockOptimistic
    rst1.Open "projectnumqry", cnn1
    DoCmd.Maximize

    Rem -----------------------------------------------
    Rem cleanup code
    rst1.Close
    cnn1.Close
    Set rst1 = Nothing
    Set cnn1 = Nothing
    ----------------------------------------------------------------------------------------------------------------------------
    First it appears that this code needs to be placed whenever a form is
    opened which does not make sense. Apparently subsequent forms do not
    inherit the record lock property which results in the error message
    that the database is "locked". Also I suspect that the cleanup code
    should actually be run when the form is closed. Opening the form with
    "Me.recordlocks=0" did NOT seem to have an effect.
     
  8. G. Vaught

    G. Vaught
    Expand Collapse
    Guest

    To truly use Access as a multi-user database your database should be split.
    The back-end should reside on a server type machine and the front-end
    resides on each users machine. If you do not do this, then the database is
    subject to corruption and total loss.

    Access has a built-in database splitter that will walk you through the
    process. However, before you do this, make a copy of the database in its
    present form.

    <ortaias@hotmail.com> wrote in message
    news:1153938139.046999.297890@m73g2000cwd.googlegroups.com...
    > The following code derived from "Programming Microsoft Access Version
    > 2002" By Rick Dobson has partially resolved the issue of getting the
    > database open as a multiuser database.
    > -------------------------------------------------------------------------------------------------------------------
    > str1 = "Provider=microsoft.jet.oledb.4.0;" & "data source=P:\Federal
    > Consistency\consistency.mdb"
    > Rem -------------------------------------------------------------
    > Rem initialize dataset
    > Set cnn1 = New ADODB.Connection
    > Set rst1 = New ADODB.Recordset
    > cnn1.Open str1
    > rst1.CursorType = adOpenKeyset
    > rst1.LockType = adLockOptimistic
    > rst1.Open "projectnumqry", cnn1
    > DoCmd.Maximize
    >
    > Rem -----------------------------------------------
    > Rem cleanup code
    > rst1.Close
    > cnn1.Close
    > Set rst1 = Nothing
    > Set cnn1 = Nothing
    > ----------------------------------------------------------------------------------------------------------------------------
    > First it appears that this code needs to be placed whenever a form is
    > opened which does not make sense. Apparently subsequent forms do not
    > inherit the record lock property which results in the error message
    > that the database is "locked". Also I suspect that the cleanup code
    > should actually be run when the form is closed. Opening the form with
    > "Me.recordlocks=0" did NOT seem to have an effect.
    >
     
  9. ortaias@hotmail.com

    ortaias@hotmail.com
    Expand Collapse
    Guest

    Thanks. This is proving to be more complex than implied by the
    documentation. I have "fixed-up" opening the ADODB connection code so
    that it opens with the database and closes with the database. However,
    I am now getting an "object variable or with block variable not set"
    error when running a "for each loop", which I think is being triggered
    from the "refrences" dialog box. I am going to play with the
    references settings today to see if that can be resolved.
     

Share This Page