dcsimg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: Access97 - Disk or network error

  1. #1
    Andrew Guest

    Access97 - Disk or network error


    Hello all,
    I hope you can help me with this because I am stumped. I have an Access97
    database that is used by myself and one other user. For some reason, if
    I start my application which connects to the database as follows...

    Set cnn = New ADODB.Connection
    cnn.CursorLocation = adUseClient
    cnn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDB.mdb";"

    ...I get a "Disk or network error" message when I try to open the database
    in Access97. I have verified, on the "Advanced" tab of the Tools->Options
    dialog , that the default open mode is "Shared" (this was the default and
    I have not changed anything). I have never run into this problem with any
    other database except this one. The problem is, that the other user will
    get the "Disk or network error" when he starts the application if I have
    the database open. I have not intentionally set anything to exclusive mode,
    and all tables and queries are owned by the "Admin" user. Does anyone know
    how I can get rid of this error?

    Thanks,
    Andrew.





  2. #2
    Arthur Wood Guest

    Re: Access97 - Disk or network error


    Andrew,
    The problem appears to be the OLEDB version. Access 97 uses 3.51, while
    the code you show appeas to be attempting to open an Access 2000 database
    (OLEDB.4.0).

    Change the OLEDB version, and see if that helps.

    Arthur Wood


    "Andrew" <andybecker@earthlink.net> wrote:
    >
    >Hello all,
    >I hope you can help me with this because I am stumped. I have an Access97
    >database that is used by myself and one other user. For some reason, if
    >I start my application which connects to the database as follows...
    >
    > Set cnn = New ADODB.Connection
    > cnn.CursorLocation = adUseClient
    > cnn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDB.mdb";"
    >
    >...I get a "Disk or network error" message when I try to open the database
    >in Access97. I have verified, on the "Advanced" tab of the Tools->Options
    >dialog , that the default open mode is "Shared" (this was the default and
    >I have not changed anything). I have never run into this problem with any
    >other database except this one. The problem is, that the other user will
    >get the "Disk or network error" when he starts the application if I have
    >the database open. I have not intentionally set anything to exclusive mode,
    >and all tables and queries are owned by the "Admin" user. Does anyone know
    >how I can get rid of this error?
    >
    >Thanks,
    >Andrew.
    >
    >
    >
    >



  3. #3
    Andrew Guest

    Re: Access97 - Disk or network error


    "Arthur Wood" <wooda@saic-trsc.com> wrote:
    >
    >Andrew,
    > The problem appears to be the OLEDB version. Access 97 uses 3.51, while
    >the code you show appeas to be attempting to open an Access 2000 database
    >(OLEDB.4.0).
    >
    >Change the OLEDB version, and see if that helps.
    >
    >Arthur Wood
    >
    >
    >"Andrew" <andybecker@earthlink.net> wrote:
    >>
    >>Hello all,
    >>I hope you can help me with this because I am stumped. I have an Access97
    >>database that is used by myself and one other user. For some reason, if
    >>I start my application which connects to the database as follows...
    >>
    >> Set cnn = New ADODB.Connection
    >> cnn.CursorLocation = adUseClient
    >> cnn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDB.mdb";"
    >>
    >>...I get a "Disk or network error" message when I try to open the database
    >>in Access97. I have verified, on the "Advanced" tab of the Tools->Options
    >>dialog , that the default open mode is "Shared" (this was the default and
    >>I have not changed anything). I have never run into this problem with

    any
    >>other database except this one. The problem is, that the other user will
    >>get the "Disk or network error" when he starts the application if I have
    >>the database open. I have not intentionally set anything to exclusive

    mode,
    >>and all tables and queries are owned by the "Admin" user. Does anyone

    know
    >>how I can get rid of this error?
    >>
    >>Thanks,
    >>Andrew.
    >>
    >>
    >>
    >>

    >


    Arthur,
    Thanks for the response. I tried this but the problem did not change. I
    have been using 4.0 for quite some time, since I installed MDAC 2.1, and
    have not had any problems with any of my applications including this one
    until recently.

    Any other ideas?

    Thanks,
    Andrew.



  4. #4
    mire Guest

    Re: Access97 - Disk or network error

    I get the same message if ODBC or some other refresh timeout is set to a
    small value. Try increasing this values (Tools, options etc.) ... I think
    it's a network related problem. Do you access remote .mdb files ? Is the hw
    compatible ?

    Andrew <andybecker@earthlink.net> wrote in message
    news:3a3527e9$1@news.devx.com...
    >
    > Hello all,
    > I hope you can help me with this because I am stumped. I have an Access97
    > database that is used by myself and one other user. For some reason, if
    > I start my application which connects to the database as follows...
    >
    > Set cnn = New ADODB.Connection
    > cnn.CursorLocation = adUseClient
    > cnn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDB.mdb";"
    >
    > ..I get a "Disk or network error" message when I try to open the database
    > in Access97. I have verified, on the "Advanced" tab of the Tools->Options
    > dialog , that the default open mode is "Shared" (this was the default and
    > I have not changed anything). I have never run into this problem with any
    > other database except this one. The problem is, that the other user will
    > get the "Disk or network error" when he starts the application if I have
    > the database open. I have not intentionally set anything to exclusive

    mode,
    > and all tables and queries are owned by the "Admin" user. Does anyone

    know
    > how I can get rid of this error?
    >
    > Thanks,
    > Andrew.
    >
    >
    >
    >




  5. #5
    Kevin Guest

    Re: Access97 - Disk or network error


    If timing out is causing the problem then use the
    ConnectionTimeOut property on the Connection object. The default is 15 seconds.
    Here is an extract from the MSDN help file
    **********************
    ConnectionTimeout Property


    Indicates how long to wait while establishing a connection before terminating
    the attempt and generating an error.

    Settings and Return Values

    Sets or returns a Long value that indicates, in seconds, how long to wait
    for the connection to open. Default is 15.

    Remarks

    Use the ConnectionTimeout property on a Connection object if delays from
    network traffic or heavy server use make it necessary to abandon a connection
    attempt. If the time from the ConnectionTimeout property setting elapses
    prior to the opening of the connection, an error occurs and ADO cancels the
    attempt. If you set the property to zero, ADO will wait indefinitely until
    the connection is opened. Make sure the provider to which you are writing
    code supports the ConnectionTimeout functionality.

    The ConnectionTimeout property is read/write when the connection is closed
    and read-only when it is open.

    ***************************

    Kevin


    "mire" <mmiroslavREMOVE-THIS@hotmail.com> wrote:
    >I get the same message if ODBC or some other refresh timeout is set to a
    >small value. Try increasing this values (Tools, options etc.) ... I think
    >it's a network related problem. Do you access remote .mdb files ? Is the

    hw
    >compatible ?
    >
    >Andrew <andybecker@earthlink.net> wrote in message
    >news:3a3527e9$1@news.devx.com...
    >>
    >> Hello all,
    >> I hope you can help me with this because I am stumped. I have an Access97
    >> database that is used by myself and one other user. For some reason,

    if
    >> I start my application which connects to the database as follows...
    >>
    >> Set cnn = New ADODB.Connection
    >> cnn.CursorLocation = adUseClient
    >> cnn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDB.mdb";"
    >>
    >> ..I get a "Disk or network error" message when I try to open the database
    >> in Access97. I have verified, on the "Advanced" tab of the Tools->Options
    >> dialog , that the default open mode is "Shared" (this was the default

    and
    >> I have not changed anything). I have never run into this problem with

    any
    >> other database except this one. The problem is, that the other user will
    >> get the "Disk or network error" when he starts the application if I have
    >> the database open. I have not intentionally set anything to exclusive

    >mode,
    >> and all tables and queries are owned by the "Admin" user. Does anyone

    >know
    >> how I can get rid of this error?
    >>
    >> Thanks,
    >> Andrew.
    >>
    >>
    >>
    >>

    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center