I am planing distribute my VB/Access application in CD-ROM format. The
problem I am facing is that VB creates a ldb lock file in the same
directory where the mdb file is located. CD-ROM is read only media. Is
there any way to redirect Vb to write out ldb file to local harddrive?
---------

Dag Sunde

There was a posting on this topic a couple of months ago. It said that the
above would work but you need to distribute a proper .ldb file on the CD
as well as your code.

The .ldb file *must* be created by opening up the database in read-write
(I can't remember if it was exclusive or shared mode), then quit.

Distribute the .mdb and the .ldb file file together and get your setup
program to open the database exclusive and read only and it *should*
work.

All of this is from memory so I recommend you get some other authority
(not MicroSoft *grin*) to confirm what I'm telling you.

Also, test it beforehand.

HTH

Jon Paine
****************************************************************
*     Jon(athan) Paine      * Phone: + 44 (0)1865 735422       *
* Computer Systems Officer  * Fax:   + 44 (0)1865 736374       *
*    Templeton  College     * E-Mail:                          *


****************************************************************
*   The Duke had a mind that ticked like a clock and, like a   *
*   clock, it regularly went CUCKOO...                         *
*                               Terry Pratchett - Wyrd Sisters *
****************************************************************

In regards to the .LDB, no, you cannot redirect it.  If it needs to be
created, it has to go in the same directory as the database file.  Believe me
I've tried everything to change it.  It's really too bad.

Justin Smith