Mark A Matte
markamatte at hotmail.com
Tue Feb 8 14:10:17 CST 2005
Susan, I tried using A97 and A2K and both said they were an unrecognized database format...I renamed them to *.mdb...tried the same...and got the same error. Thanks, Mark >From: "Susan Harkins" <ssharkins at bellsouth.net> >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 14:14:58 -0500 > > >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 > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com