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

Mark A Matte markamatte at hotmail.com
Tue Feb 8 12:31:46 CST 2005


Hello All,

I had never heard of an *.md1 before...but I searched my machine and found 
something in a system folder...the machine is Win2k server with A97 and 
A2K...the file is iischema-update.MD1 and there is also a 
iischema-update.MD0 .  The folder is d:\winnt\system32\inetsrv\metaback

I have no idea what it is or where it came from...but it does look like it 
was created during a service pack install.

Just thought I'd through it out there in case it made sense to someone.

Thanks,

Mark


>From: "Steve Conklin (Developer at UltraDNT)" <Developer at ultradnt.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: RE: [AccessD] What is this .md1 That Is Locking My Security File?
>Date: Tue, 8 Feb 2005 13:04:40 -0500
>
>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