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

John Bartow john at winhaven.net
Tue Feb 8 13:40:10 CST 2005


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




More information about the AccessD mailing list