[AccessD] Weird A97 happenings

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, 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
>