Results 1 to 8 of 8

Thread: error reading a database from cd

  1. #1

    Thread Starter
    New Member
    Join Date
    Nov 1999
    Posts
    10

    Post

    We are making an application that will read data from the cd .We're having a problem reading a ms access database from the cd. It keeps on displaying that the database has been exclusively opened by another user.
    What seems to be the possible cause of this?

  2. #2
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,175

    Post

    A database that is Read-only will give you that error. Since it's on a CD, and you usually can't write to a CD, maybe that's the problem.
    ------------------
    Marty

    [This message has been edited by MartinLiss (edited 01-13-2000).]

  3. #3
    Addicted Member
    Join Date
    Jan 1999
    Location
    Sydney,NSW,Australia
    Posts
    178

    Post

    Also if you have opened the file in one form and not closed it.

  4. #4
    PowerPoster
    Join Date
    Jul 1999
    Posts
    5,923

    Post

    Make sure also that if you are using the OpenDatabase method that you have set the Options variable to False

    e.g.

    Dim ODb as Database

    Set ODb=OpenDatabase(YourDbPath,False,False,ConnectString)

    Connect string is usually for passwords (";pwd=" & "YourPassword")

    This would only happen though if the file is being used elsewhere (like Access itself is open or more than one copy of your app is running...)

    Regards,

    ------------------
    - Chris
    chris.kilhams@btinternet.com
    If it ain't broke - don't fix it


    [This message has been edited by chrisjk (edited 01-14-2000).]

  5. #5
    old fart Frans C's Avatar
    Join Date
    Oct 1999
    Location
    the Netherlands
    Posts
    2,926

    Post

    When opening an access database, a locking file will be created in the same directory as the database (eg Mydatabase.ldb).
    If the databse is on a cd, this isn't possible and an error is generated.
    I don't know a solution for this.

  6. #6
    Addicted Member
    Join Date
    Jul 1999
    Location
    Portland, OR.
    Posts
    226

    Post

    Hi.

    It seeme that the only way is to copy your .MDB to a Temp Dir, then open it, read it and finally Kill it

    Good Luck.

  7. #7
    Hyperactive Member gravyboy's Avatar
    Join Date
    Jan 2000
    Location
    Where I was before . . . if you don't know then you're new!
    Posts
    334

    Post

    It seems to me that you are chasing a very fast car!

    If the database is on CD why don't you create a vb front end (on the CD) that uses any of the data access technologies to view the data. I say this because you cannot write data back to the CD anyway.

    This will eliminate the *.ldb problem!

    Hope this helps . . .

    ------------------
    Matt G
    Either mattg@gravyboy.fsnet.co.uk] or matt.graveston@centrica.co.uk

  8. #8
    Addicted Member
    Join Date
    Oct 1999
    Location
    Oporto, Portugal
    Posts
    134

    Post

    I'm not sure about this but...have you tried to open the DB for exclusive reading?



    ------------------
    Jorge Ledo
    j_ledo@hotmail.com
    Portugal

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width