John Bartow
john at winhaven.net
Tue Feb 8 21:36:56 CST 2005
OK, I sit corrected :o)) Glad I could bring a little bit of laughter to people (even if it is at my expense :o) I remember doing that naming game for some reason or another a few years back. Renamed the .mdb to .jrb or something. Can't remember if I compiled or compacted it though! 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: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