[AccessD] What is this .md1 That Is Locking My Security File?

John Bartow john at winhaven.net
Tue Feb 8 21:45:17 CST 2005


Don't get one - they suck.

They tend to get you a lot of ribbing too :o)


John B. 

 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby
Sent: Tuesday, February 08, 2005 9:31 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] What is this .md1 That Is Locking My Security File?

ROTFLMAOBTC.

You MIGHT find a reason to COMPILE an MDE.

And I don't even have one of these whizbang MS keyboards.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby
Sent: Tuesday, February 08, 2005 10:13 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] What is this .md1 That Is Locking My Security File?


ROTFL.

Yea, it never made much sense to me to compile an MDE either.

;-)

It's a little known fact though that you can rename an MDB/A/E to any
extension you want and it is still a database container.  Thus you could
rename your MDA to MDE, in which case you MIGHT find a reason to compact an
MDE!

LOL

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
Sent: Tuesday, February 08, 2005 10:01 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] What is this .md1 That Is Locking My Security File?


..this just gets better and better :))))

William Hindman

----- Original Message -----
From: "John Bartow" <john at winhaven.net>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Tuesday, February 08, 2005 9:56 PM
Subject: RE: [AccessD] What is this .md1 That Is Locking My Security File?


> OOPS!  ee-gads that looked pretty stupid!
>
> I'm blaming it on my wireless keyboard problems! (even if that is a
> stretch)
> :o)
>
> I meant "generally I don't see the need for compiling an mde".
>
>
> John B.
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte
> Foust
> Sent: Tuesday, February 08, 2005 3:13 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] What is this .md1 That Is Locking My Security File?
>
> Compiling and compacting are two different things, John.
>
> Charlotte Foust
>
>
> -----Original Message-----
> From: John Bartow [mailto:john at winhaven.net]
> Sent: Tuesday, February 08, 2005 11:40 AM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] What is this .md1 That Is Locking My Security
> File?
>
>
> Steve,
> I agree, generally I don't see the need for compiling an mde. I did it
> once that I can think of and that was for a work around which used 
> temp tables in the mde. Eventually I found a better solution.
>
> But as I stated earlier: not every Access developer is as good as you
> AccessD-er gurus! (and I mean that in all sincerity)
>
> John B.
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve
> Conklin
> (Developer at UltraDNT)
> Sent: Tuesday, February 08, 2005 12:05 PM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] What is this .md1 That Is Locking My Security
> File?
>
> I know what you mean about the keybd, I have one from M$ and it does
> similar. What I meant was, while you can compact an mde,why would you, 
> its redundant. (Well, as I write this , I am thinking if you use temp 
> tables, you would want to ....) But, its my app,I'm not compactng 
> anywhere in it, and I don't have an MDW.  I'm just trying to paint a 
> full picture to the original poster as well, but she seems not to be 
> reading her thread today!
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
> Sent: Tuesday, February 08, 2005 12:38 PM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] What is this .md1 That Is Locking My Security
> File?
>
>
> Sorry, should have been a paragraph in there.
>
> (I have a (expensive) Logitech wireless keyboard and yesterday it
> started giving me grief. Skips keystrokes, won't send keystrokes at 
> all. I changed batteries and it still is acting up! Very frustrating!)
>
> The security I was referring to was the person who's mdw was shadowed
> by a md1.
>
> An MDE can be compacted, in version A97 or A2k3 anyway. I was
> suggesting that it was either happening as a bug or expressly via the 
> user code. If for some reason it hangs up the compaction process 
> leaves behind a copy used in the process. Now normally IIRC correctly 
> the filename is db1 or something but I don't know how hard and fast 
> that rule is. You can of course create a copy with another name in 
> code but I would guess you probably know if you're doing that or not - 
> however if this is a project you picked up from another then you may 
> not. I deal with other access developers apps which leave the compact 
> on exit thing turned on in the FE. There is no reason for it other 
> than they probably aren't aware they can turn it off. Not everyone 
> there is as good as you AccessD-ers! (and I mean that in all 
> sincerity)
>
> It was all just rambling thouths I had in an attempt to help out.
>
> John B.
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve
> Conklin
> (Developer at UltraDNT)
> Sent: Tuesday, February 08, 2005 10:44 AM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] What is this .md1 That Is Locking My Security
> File?
>
> Well, there is no security on the application where I found this ...
> And there shouldn't be any compact on an MDE. Its still a mystery to 
> me what this file is about.
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow
> Sent: Tuesday, February 08, 2005 11:00 AM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] What is this .md1 That Is Locking My Security
> File?
>
>
> Just a wild thought but given that it is almost the same size it
> sounds as if it is a failed compacting process. Could there be some 
> glitch that causes this app to compact the security file?
>
>
> John B.
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve
> Conklin
> (Developer at UltraDNT)
> Sent: Tuesday, February 08, 2005 9:49 AM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] What is this .md1 That Is Locking My Security
> File?
>
> PS:  It is too large to be a lock-file, it is ALMOST the same size as
> the application , but not exactly the same.
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson,
> Karen
> Sent: Friday, February 04, 2005 6:45 AM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] What is this .md1 That Is Locking My Security 
> File?
>
>
> My loading of the database already refers to the mdw.  I am doing a
> new upload of the database in about 10 minutes.  That is when the md1 
> will appear, if it is going to.  Here we go...
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim
> Lawrence
> Sent: Thursday, February 03, 2005 9:13 PM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] What is this .md1 That Is Locking My Security
> File?
>
>
> Hi Karen:
>
> I have not been keeping up with the list but here is my comment.
>
> I think the md1 file is actually a mdw file that has been renamed and
> incorporated as some form of security. Why do you not leave or change 
> it's extension to mdw and load your app in the standard way.
>
> 'C:\progarm file\Office\11\msacccess.exe
> c:\MyDirectory\MyApplication.mdb /wrkgrp 
> c:\MyDirectory\MyApplication.mdw' or 
> 'c:\MyDirectory\MyApplication.md1'
>
> HTH
> Jim
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson,
> Karen
> Sent: Thursday, February 03, 2005 8:19 AM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] What is this .md1 That Is Locking My Security 
> File?
>
> No idea.  I'll play the waiting game.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
> Hindman
> Sent: Thursday, February 03, 2005 10:52 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] What is this .md1 That Is Locking My Security 
> File?
>
>
> ..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
>>
> --
> 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
>
> --
> 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



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list