[AccessD] Weird A97 happenings

Gary Kjos garykjos at gmail.com
Wed Mar 28 11:23:08 CDT 2007


Yea for backups!

GK

On 3/28/07, John Clark <John.Clark at niagaracounty.com> wrote:
> I would like to thank everybody for their help, but nothing was working, and I found that our backup that ran, on Monday evening, would put us back to working condition w/out losing any data, so I had it restored off of a backup tape.
>
> It does bug me though...why exactly it happened. I suspect that somebody was playing around and they're afraid to say anything. The only time I have had to work on this program...like I said, it is real simple...is when they hired a volunteer that was finishing up school at a local university for w/a computer related degree, and he decided to play w/the program one night. My programs aren't locked down real good, because I generally don't need them to be, but I think I may have to change this.
>
> Thanks again for all the help...as usual!
>
> John W Clark
>
> >>> "JWColby" <jwcolby at colbyconsulting.com> 3/28/2007 8:21 AM >>>
> If this is simply a password to get in, I think there is unlock code.  I got
> it from Shamil one time IIRC.  I have the code somewhere but finding it...
>
>
> 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: Wednesday, March 28, 2007 8:08 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Weird A97 happenings
>
> 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
>
> --
> 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



More information about the AccessD mailing list