[AccessD] Weird A97 happenings

JWColby jwcolby at colbyconsulting.com
Tue Mar 27 14:18:41 CDT 2007


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




More information about the AccessD mailing list