[AccessD] ShellExecuteA

Jurgen,

If you're still having problems, can you open the file from your screen
using a hyperlink?  I've always had good luck with this method.  If you have
the path to the file, that's all you need to get started.

Dan Waters

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of J?rgen Welz
Sent: Saturday, December 03, 2005 1:38 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] ShellExecuteA

Hey Stuart:

Permissions are set in tightly regulated profiles that are cloned from a 
standard set.  IT is regenerating profiles for all users of my application 
as there has been some rare corruption in the past.

I had never personally had explorer fail to open a .pee file but when I had 
the IT person try my login, it failed for him.  The most difficult aspect of

this is the apparent random nature of the problem.  Some people have fewer 
problems and they vary from day to day and in the course of a day.

The application with which we have a difficulty has an application which is 
supposedly required for file management and stores stats and other meta data

regarding the 1000's of files we create every year.  We have never used the 
features of this application because the Access application does all the 
file management and gives us a far more flexible means of managing our data.

  I discovered that this component of the system has not yet correctly been 
installed as the license manager software does not permit this component to 
load.  I now suspect that the "File not Found" return from both ShellExecute

(value is 2 -  Marty) and the Win Explorer interface relates to storing meta

data in this component of the application.

IT installed this upgrade 4 weeks ago on a Friday night and on Saturday I 
received a panic call that no one could open any .Pee files.  The file 
format changed from v9.1 to 9.2 and had to upgrade some 20,000 thousand 
files needed for access to needed and potentially needed data.  And their 
year end is Oct 31.  There is a tool that upgrades all files below a user 
defined sub folder, but this crashed hundreds of times so I wound up taking 
it in ever smaller chunks.  I now suspect that the crashes were due to the 
failure to sucessfully install the component that collects the data about 
the files.  What a great way to negotiate a new job and wage...


Ciao
Jürgen Welz
Edmonton, Alberta
jwelz at hotmail.com





>From: "Stuart Sanders" <lists at bitshk.com>
>
>Hi Jurgen,
>
>Taking a complete stab in the dark here, but since you mentioned this is a
>locked down terminal services environment, is it possible there are user
>permission issues on the upgraded application?
>
>Stuart