[AccessD] Weird A97 happenings

Gary Kjos garykjos at hotmail.com
Tue Mar 27 15:07:17 CDT 2007


You have compacted and repaired of course?  When they started using it under 
A2K was it converted to be an A2K database?  Does anyone now have a later 
version of Access? Have they by chance gotten a new PRINTER?  sounds odd but 
I have had LOTS of problems due to users switching to multifunction 
printer/scanner/fax devices from regular printers.

Can you create a new blank database and then import all the individual 
objects into that?  Perhaps you would want to do that on one of the users 
systems if they are using a different version of Access than you are or 
since they don't get the password prompt.

Good luck. No doubt once you figure it out it will be something basic. So 
look at basic stuff first ;-)  Easy for ME to say.

GK

Gmail is not working for me again today ----- Grrrr



Gary Kjos
garykjos at hotmail.com





>From: "John Clark" <John.Clark at niagaracounty.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: [AccessD] Weird A97 happenings
>Date: Tue, 27 Mar 2007 14:42:53 -0400
>
>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





More information about the AccessD mailing list