Bob Heygood
bheygood at abestsystems.com
Wed May 31 11:31:13 CDT 2006
Kind Responders, Yeah, I tested and as far as I can see no .ldb is being created. I just get a warning that we are in "Read Only" mode. Thot maybe Access/Windows was creating one on the "fly" as I am using a drive capable of burning files. This is a curiosity as I always found an .ldb when opening an .mdb and actually have had issues where I did not have rights to create one. thx, bob heygood -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Dettman Sent: Wednesday, May 31, 2006 8:35 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] ldb Stuart, Actually, that's not quite right. If Access/JET can't create an .LDB file, the database is placed in exclusive mode. The read-only is a separate issue. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Tuesday, May 30, 2006 10:26 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] ldb It will work - as long as you only want to view the content. When you open an Access .mdb on a CD, Access can't write the .ldb file so you get a pop- up warning that the file is RO and that you won't be able to save changes. You don't need to have an LDB file to open an Access database, as long as you are only accessing data and not trying to modify it. On 30 May 2006 at 19:52, Jim Hewson wrote: > The lbd is located in the same directory as the mdb. > Therefore, unless the CD is a CDRW it won't work. > Have the client copy the mdb to the hard drive and then run it. > Most of the time when the mdb is copied from a read-only CD, it's also > read-only. If that is the intent (that is, keep it read-only) then > nothing needs to be done. If you want the mdb to be read-write then > looking at the properties of file will reveal the read-only checkbox > is checked. Uncheck the it and you're good. HTH Jim > > ________________________________ > > From: accessd-bounces at databaseadvisors.com on behalf of Bob Heygood > Sent: Tue 5/30/2006 7:38 PM To: Access Developers discussion and > problem solving Subject: [AccessD] ldb > > > > Hello List, > When advising a client about trying to run his dB from a CD, I had a > thot. Where does Access place the .ldb when running a read only .mdb? > > Anyone have an idea? > > best, > > bob heygood > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com