Gary Kjos
garykjos at gmail.com
Wed Mar 28 07:37:20 CDT 2007
Did you say you could open it from one of the users desktops without being asked for a password? Could you try it from there? Do they have other applications that could be secured that may have altered the system.mdw file? GK On 3/28/07, John Clark <John.Clark at niagaracounty.com> wrote: > Well, I tried this, but before I could I could import from the old program, I was prompted for a password. > > So, I guess my biggest problem, at this moment, is that there is no password for the program, yet I am being asked for one. I tried blanks but they didn't work either. Why would a program begin asking for a password? > > > > >>> "JWColby" <jwcolby at colbyconsulting.com> 3/27/2007 3:18 PM >>> > I would guess that the data store is still in A97 and the Access itself is > in A2K. A2K could read but not write (forms / code etc) to an A97 > container. Build a new container in A2K and import all of the objects into > that container. > > > John W. Colby > Colby Consulting > www.ColbyConsulting.com > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark > Sent: Tuesday, March 27, 2007 3:01 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Weird A97 happenings > > I think I explained wrong...there is the password prompt only on my PC using > A97 and A2K3, and now we get the same thing using my co-worker's PC that has > A2K7. The error message that I am getting on their PC is on a A2K > installation. > > > >>> "David McAfee" <davidmcafee at gmail.com> 3/27/2007 2:52 PM >>> > The security message is part of your 2003 installation. You can go to > Tools->options->Security and lower the level. As for the login prompt, > Tools->options->there > is probably something going on with the mdw. DO you have another secured mdb > on your box? that app may not be set up correctly. Check out the securityFaq > white paper. If you cant find it on Microsoft's site, check out > RogersAccesslibrary.com and it is there. > > You can also (band aid fix) create a shortcut and put a username and > password in the command line of the short cut (I believe even if the pw is > blank). > > > > On 3/27/07, John Clark <John.Clark at niagaracounty.com> wrote: > > > > Years ago, I wrote a A97 program for our Hotline program. This is the > > program that you call if you are going to hurt yourself, and is part > > of the Mental Health department. > > > > It really isn't anything very complex and they have been using it for > > all these years w/out any problems. It is one of the first programs I > > wrote in Access, so there really isn't any big programming tricks going > on. > > > > Basically, it opens via the "Startup" options, to a form called, > > "HotlineSplash" which OnTimer then closes, and OnClose is goes to the > > "HotlineMenu" form. The first problem that they encountered was that > > it wouldn't make the switch from the splash screen to the menu. It > > gave the standard error message about a macro or code that could not > > be run...the first message listed OnTimer as a problem. > > > > I'll interject here that I wrote the program using A97, but they have > > since switched to A2K. I believe this was done early in 2006 (yeah, > > we're always a bit behind). > > > > The first "Odd" thing that I notice, when I was nosing around, was > > that I encountered a message that said something like, "You cannot > > make any changes because this was written in an earlier version of > > hotline." It apparently picked up the name of the program and put it > > in the place of the word "access." > > > > I figured that a quick fix, to get them going, and I could look at the > > real problem later, would be to skip the splash screen. So, I went > > into the startup area and made the switch to open to the menu. It > > seemed to work, because it came up to the menu and had no error. > > However, as soon as I try to push a command button choice, a similar > > error occurs. Basically, an error appears when any function is > > attempted, other than simply opening an object from the Access menu. > > > > I have A97 and A2003 installed on my PC, so I figured I'd make a copy > > and look at it from my desk...I was remote controlling their PC > originally. > > Whether I use A97 or 2K3, on my PC, I get a password screen. It > > doesn't have a password. And, when I was using it from the desktop, I > > didn't have to enter a password. > > > > ANY ideas here would be greatly appreciated! At this point, I'm ready > > to drop back and punt. If your advice is to leave work and go get a > > drink, I would probably heed your advice ;o) > > > > Thank you! > > > > John W Clark > > > > -- > > 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 > -- Gary Kjos garykjos at gmail.com