William Hindman
dejpolsys at hotmail.com
Thu Feb 3 09:52:25 CST 2005
..wag of course, but could the db be using any temp dbs and naming them with the md1 extension when it creates them? William Hindman ----- Original Message ----- From: "Nicholson, Karen" <cyx5 at cdc.gov> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Thursday, February 03, 2005 10:38 AM Subject: RE: [AccessD] What is this .md1 That Is Locking My Security File? >I am not that dumb. I do admit to trusting the wrong people. Of course > I get the .ldb s on the databases. This is actually the number one. > Next time it happens, I will take a screen shot and announce that I have > *the evidence*. The *evidence* will surely float to the surface again > in the next week. So let's wait until it happens again, maybe if I can > list all the files that are showing up it can be figured out. Thanks! > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > GregSmith at starband.net > Sent: Thursday, February 03, 2005 10:24 AM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] What is this .md1 That Is Locking My Security > File? > > > Well, I can't figure out why you're not getting the corresponding ldb > file > that's assocated with all of the MSAccess versions and their db's. What > OS are you running on? What version of Access are you using? Can you > make sure you ARE getting those ldb files on the databases? If not, > there's something really adrift here. > > I don't doubt you are getting what you say you are...you should know! > ;) > We need a few more puzzle pieces yet...but we'll get it put together... > > >> I swear that this is a one and not an L. It is not present when users >> have the database is opening, using the rb.mdw file and all is well. > It >> only locks occassionally. Next time it locks, I will put on my specs, >> but I am pretty darn sure it is a 1. >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Erwin Craps > - >> IT Helps >> Sent: Thursday, February 03, 2005 1:44 AM >> To: Access Developers discussion and problem solving >> Subject: RE: [AccessD] What is this .md1 That Is Locking My Security >> File? >> >> >> Sorry my mistake >> >> You are correct, I just presumed the 1 was misread with a l and did > not >> think any further.... >> >> Erwin >> >> >> -----Oorspronkelijk bericht----- >> Van: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] Namens >> GregSmith at starband.net >> Verzonden: woensdag 2 februari 2005 16:20 >> Aan: accessd at databaseadvisors.com >> Onderwerp: RE: [AccessD] What is this .md1 That Is Locking My Security >> File? >> >> I've always had and ldb (small "L") file present when someone logs > into >> a database...and for a split db, there is one for the FE, one for the > BE >> and one for the security file...but they're all ldb, not md"x" files. >> The security file, SecFile.mdw would have a corresponding SecFile.ldb >> associated with it when someone logs in. Same with the FE and BE >> files-a corresponding *.ldb file. I can't find any reference anywhere >> to mdl (small "L") on M$ or Google... >> >> If you login "Exclusively" to a db, then this ldb file does not open, >> letting Access know that nobody else can login because the file is >> 'locked' by an exclusive user. >> >> Greg >> >>> This is probably a mdl file (l not 1). >>> A mdl file is always present when somebody has opened the database >>> file, in this case the security file. >>> In this file all locks are kepded and is needed for Access to > operate. >>> >>> This does not cause any lockouts for users unless some bad > programming >> >>> or other (security?) issues. >>> >>> >>> Erwin >>> >>> >>> -----Original Message----- >>> From: accessd-bounces at databaseadvisors.com >>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson, >>> Karen >>> Sent: Tuesday, February 01, 2005 5:26 PM >>> To: accessd at databaseadvisors.com >>> Subject: [AccessD] What is this .md1 That Is Locking My Security > File? >>> >>> Now Access is being rude to me. I recently moved the security file >>> that controls my database from each person's own hard drive to a >>> centralized location on the network. Every couple of days, the >>> security file named rb.mdw has a friend, rb.md1, locking out most of >>> the users. Does anyone know what this is and how to prevent it? >> Thanks. >>> -- >>> 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 >> -- >> 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 > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >