[AccessD] Problem Validating Program Error

[Stuart McLachlan]

Hard coded CSV file name in 'Program Files" cause a "validation error" message?  Looks like 
either a stupid place to store options or a VERY ill thought out attempt at copy protection (or 
possibly both).

You'd better be prepared for a few more surprises if the developer did things like that :(


On 14 Jul 2019 at 14:14, David Emerson wrote:

> 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
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>