[AccessD] Problem Validating Program Error

[David Emerson]

Hi Bill,

Your confusion is well founded.  I looked further into the code (it wasn't
mine).  The message was actually a message put into the error trapping.

The code that caused the message was this:

    strFile = "C:\program files\PCS4.csv"
    lngFileHandle = FreeFile
    Open strFile For Input Access Read As lngFileHandle

The csv file is used to store information that is used in the setup of the
Access screen.  Because the file didn't exist Access showed the message.


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Bill Benson
Sent: Sunday, 14 July 2019 10:34 a.m.
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Problem Validating Program Error

Wait - I am confused. Access was looking for a file that did not exist? As
in, one of its installation files? Or some other file? The reason I ask is
because I am not familiar with an Access native message saying that there
is a problem validating the (Access?) program. Is that a message that
happens if one of Access's own files is missing? Or was this a home grown
error message within this particular application that was in response for
checking a for a user or developer created file?

TIA

On Fri, Jul 12, 2019 at 4:14 PM John Colby <jwcolby at gmail.com> wrote:

> LOL.  The old "file doesn't exist" problem.  I know it well.
>
> On Thu, Jul 11, 2019 at 11:08 PM David Emerson <newsgrps at dalyn.co.nz>
> wrote:
>
> > Found the problem.  The program code was looking for a file that didn't
> > exist.
> >
> > -----Original Message-----
> > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> > David Emerson
> > Sent: Thursday, 11 July 2019 5:44 p.m.
> > To: 'Access Developers discussion and problem solving'
> > Subject: [AccessD] Problem Validating Program Error
> >
> > Hi Listers,
> >
> >
> >
> > A client has just purchased a new computer with Windows 10 running
Office
> > 2013.  They previously had Windows 7 running Access 2013.  They are
> running
> > a local Access mdb linked to another mdb on a server.
> >
> >
> >
> > When they try to open an Access mdb file they get this error message
> "There
> > is a problem with validating the program.  The program will be closed
> > down."
> > This error message pops up after the program opens and has retrieved
data
> > to
> > show on the first screen.
> >
> >
> >
> > 2 other users that are still on Windows 7 have no problems.
> >
> >
> >
> > Has anyone come across this before?  Mr Google doesn't come up with
> > anything.
> >
> >
> >
> > Regards
> >
> > David Emerson
> > Dalyn Software Ltd
> > Wellington, New Zealand
> >
> >
> >
> >
> >
> > --
> > 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
> >
>
>
> --
> John W. Colby
> Colby Consulting
> --
> 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