Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unanswered: VB6 opening an MS Access Database on CD

    I have a vb6 program that connects to an Access Database. I need this database to be read from a CD. Obviously the CD is read-only, which is OK. The program does not need to be able to write to the database, only read. The first time the program goes to open a recordset, I get a 'could not lock file' error. I assume that this is because the program needs to change the db 'a little bit' just to say it is OPEN. I am using a data environment, and the database connection is set to read-only, and the command's lock type (for the table) is set to read-only. Am I missing something? Or can this just not be done?

  2. #2
    Join Date
    Oct 2003
    Posts
    2

    Figured it out

    It is NOT possible. Ended up writing an auto-run that copied the DB to the local Hard Drive. The program than ran it from there.

    Indirectly figured this out from this MS kb article

    http://support.microsoft.com/default...b;en-us;279364

  3. #3
    Join Date
    Oct 2003
    Location
    Tijeras, NM
    Posts
    12

    Re: Figured it out

    Originally posted by Seratula
    It is NOT possible. Ended up writing an auto-run that copied the DB to the local Hard Drive. The program than ran it from there.

    Indirectly figured this out from this MS kb article

    http://support.microsoft.com/default...b;en-us;279364
    You saved me a boatload of trouble. I had to do this with a Sql Server database a couple of years ago and it was a royal pain. I was telling my boss we should do this in Access and he agreed. Now I have to figure out a better way. Keep us posted, ok?
    I love animals. They're delicious.

Posting Permissions

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