Susan Harkins
ssharkins at bellsouth.net
Tue Feb 8 13:14:58 CST 2005
Have you tried changing the extension to mdb and trying to open it? Susan H. 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com