Hi
I've been using the AutoFE for over two years now, and it works fine.
However, I want to use the %appdata% variable, which is only available in
newer versions.
I can't seem to get the latest version to work. I keep getting the same
error message, as below.
I've tried just updating the sample INI that came with 1.76, and its still
the same error.
Can someone have a quick look at this, to see if I'm doing anything
obviously wrong.
Thanks
Simeon


1019 - The following error occurred while attempting to determine the
Access/Jet version of the file 'X:\AutoFE\Test_Prog\\SSP_XP.ade' (while
using DAO Version 3.6)

Error: 0

---------- X:\AutoFE\Test_INIs\SSP_Test.ini--------------------
[Settings]
MainApp=%appdata%\My Database\
FileNameToStart=SSP_XP.ade
Server=X:\AutoFE\Test_Prog\

StartMethod=AutoSelect
Lockout=No
LockoutMsg=Sorry, not allowed into the system right now.
SupportMsg=Please contact your computer department for support.

ShortCutName=An excellent Access application
CreateShortCutOnDesktop=yes
CreateShortCutOnCommonDesktop=no
--------------------------------------------------------------------------------
Auto FE Updater Version: 1.76.0
Windows Version: Windows XP 5.1 build 2600 (Service Pack 3)

"SimeonD" <(E-Mail Removed)> wrote:

>I've been using the AutoFE for over two years now, and it works fine.
>However, I want to use the %appdata% variable, which is only available in
>newer versions.
>I can't seem to get the latest version to work. I keep getting the same
>error message, as below.
>I've tried just updating the sample INI that came with 1.76, and its still
>the same error.
>Can someone have a quick look at this, to see if I'm doing anything
>obviously wrong.

The problem and not very good answer is buried deep in the following
page: http://www.granite.ab.ca/access/autofe.htm

Bugs and Problems

StartMethod=AutoSelect does not work with ADP files. I will be
working on a solution to this problem sometime soon. I'd suggest
using version V1.65 for now. Email me if this is a problem and I'll
see what I can do.

Note that I have no idea when I will have the time to fix this
problem.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/

Ah, I actually had no StartMethod=AutoSelect in my original, and I still had
the same problem.
Using 1.65, I get the message below.
I'll email your granite address.
Thanks for your help


*******************************************************************
The following error occurred while attempting to determine the Access/Jet
version of the file 'V:\APPS\SSP\ssp.ade' (while attempting to use DAO
Version 3.6)

Error: 3343 Unrecognized database format 'V:\APPS\SSP\SSP.ade'.

---------- C:\AutoFE\SSP.ini--------------------
[Settings]
MainApp=c:\program files\SSP\ssp.ade
Server=V:\APPS\SSP
;ShortCut=V:\APPS\AutoFE\SSP.lnk
;CommandLine=/runtime
;Shell=C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE
Lockout=No
LockoutMsg=Sorry, not allowed into the system right now.
CreateShortCutOnDesktop=No


;http://www.granite.ab.ca/access/autofe.htm
--------------------------------------------------------------------------------
Auto FE Updater Version: 1.65
Windows Version: Windows XP 5.1 build 2600 (Service Pack 3)
User: 123
Workstn: abc
--------------------------------------------------------------------------------


"Tony Toews [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "SimeonD" <(E-Mail Removed)> wrote:
>
>>I've been using the AutoFE for over two years now, and it works fine.
>>However, I want to use the %appdata% variable, which is only available in
>>newer versions.
>>I can't seem to get the latest version to work. I keep getting the same
>>error message, as below.
>>I've tried just updating the sample INI that came with 1.76, and its still
>>the same error.
>>Can someone have a quick look at this, to see if I'm doing anything
>>obviously wrong.
>
> The problem and not very good answer is buried deep in the following
> page: http://www.granite.ab.ca/access/autofe.htm
>
> Bugs and Problems
>
> StartMethod=AutoSelect does not work with ADP files. I will be
> working on a solution to this problem sometime soon. I'd suggest
> using version V1.65 for now. Email me if this is a problem and I'll
> see what I can do.
>
> Note that I have no idea when I will have the time to fix this
> problem.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
> Granite Fleet Manager http://www.granitefleet.com/

Btw, both versions work fine when I use mdb.
But won't work when I use ADP or ADE.


"SimeonD" <(E-Mail Removed)> wrote in message
news:u%(E-Mail Removed)...
> Ah, I actually had no StartMethod=AutoSelect in my original, and I still
> had the same problem.
> Using 1.65, I get the message below.
> I'll email your granite address.
> Thanks for your help
>
>
> *******************************************************************
> The following error occurred while attempting to determine the Access/Jet
> version of the file 'V:\APPS\SSP\ssp.ade' (while attempting to use DAO
> Version 3.6)
>
> Error: 3343 Unrecognized database format 'V:\APPS\SSP\SSP.ade'.
>
> ---------- C:\AutoFE\SSP.ini--------------------
> [Settings]
> MainApp=c:\program files\SSP\ssp.ade
> Server=V:\APPS\SSP
> ;ShortCut=V:\APPS\AutoFE\SSP.lnk
> ;CommandLine=/runtime
> ;Shell=C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE
> Lockout=No
> LockoutMsg=Sorry, not allowed into the system right now.
> CreateShortCutOnDesktop=No
>
>
> ;http://www.granite.ab.ca/access/autofe.htm
> --------------------------------------------------------------------------------
> Auto FE Updater Version: 1.65
> Windows Version: Windows XP 5.1 build 2600 (Service Pack 3)
> User: 123
> Workstn: abc
> --------------------------------------------------------------------------------
>
>
> "Tony Toews [MVP]" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> "SimeonD" <(E-Mail Removed)> wrote:
>>
>>>I've been using the AutoFE for over two years now, and it works fine.
>>>However, I want to use the %appdata% variable, which is only available in
>>>newer versions.
>>>I can't seem to get the latest version to work. I keep getting the same
>>>error message, as below.
>>>I've tried just updating the sample INI that came with 1.76, and its
>>>still
>>>the same error.
>>>Can someone have a quick look at this, to see if I'm doing anything
>>>obviously wrong.
>>
>> The problem and not very good answer is buried deep in the following
>> page: http://www.granite.ab.ca/access/autofe.htm
>>
>> Bugs and Problems
>>
>> StartMethod=AutoSelect does not work with ADP files. I will be
>> working on a solution to this problem sometime soon. I'd suggest
>> using version V1.65 for now. Email me if this is a problem and I'll
>> see what I can do.
>>
>> Note that I have no idea when I will have the time to fix this
>> problem.
>>
>> Tony
>> --
>> Tony Toews, Microsoft Access MVP
>> Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
>> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
>> Granite Fleet Manager http://www.granitefleet.com/
>
>

"SimeonD" <(E-Mail Removed)> wrote:

>Btw, both versions work fine when I use mdb.
>But won't work when I use ADP or ADE.

Correct. That's because I can use DAO to determine the Access version
in which an MDB/MDE is created so I can tell which version of Access
that is installed on the client system to start. However I can't
use DAO to determine the Access version in which an ADP/ADE is
created.

I need to either figure out how to determine the version of an ADP/ADE
or to figure out a method of ignoring this logic for ADP/ADEs and
doing something a bit different.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/

"SimeonD" <(E-Mail Removed)> wrote:

>Ah, I actually had no StartMethod=AutoSelect in my original, and I still had
>the same problem.

But StartMethod=AutoSelect is the default. If you can use a
different method there that would also take care of the problem.

>Using 1.65, I get the message below.

Hmm, then I have no idea. I'll have to think about this a bit.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/

"Tony Toews [MVP]" <(E-Mail Removed)> wrote:

>I need to either figure out how to determine the version of an ADP/ADE

Hmm, there might be a way using ADO. Actually very similar to DAO
with slightly different syntax.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/

"Tony Toews [MVP]" <(E-Mail Removed)> wrote in
news:(E-Mail Removed):

>
> "Tony Toews [MVP]" <(E-Mail Removed)> wrote:
>
>>I need to either figure out how to determine the version of an
>>ADP/ADE
>
> Hmm, there might be a way using ADO. Actually very similar to DAO
> with slightly different syntax.

But, oh, isn't it so GREAT!!!!! that ADPs don't use Jet?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

For comparison, here is the version that works with 1.4:

[Settings]
MainApp=c:\program files\SSP\ssp.ade
Server=V:\APPS\SSP
ShortCut=V:\APPS\AutoFE\SSP.lnk

Lockout=No
LockoutMsg=Sorry, not allowed into the system right now.
CreateShortCutOnDesktop=No


I realise you're a busy man, so extra thanks for you help on this. Do you
still need me to email you?
Btw, I read your blog most days, I wonder will this newsgroup post appear on
google.....



"Tony Toews [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "SimeonD" <(E-Mail Removed)> wrote:
>
>>Ah, I actually had no StartMethod=AutoSelect in my original, and I still
>>had
>>the same problem.
>
> But StartMethod=AutoSelect is the default. If you can use a
> different method there that would also take care of the problem.
>
>>Using 1.65, I get the message below.
>
> Hmm, then I have no idea. I'll have to think about this a bit.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
> Granite Fleet Manager http://www.granitefleet.com/

"SimeonD" <(E-Mail Removed)> wrote:

>I realise you're a busy man, so extra thanks for you help on this. Do you
>still need me to email you?

No.

>Btw, I read your blog most days,

Glad I have readers there too.

>I wonder will this newsgroup post appear on
>google.....

It should.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/