Tony's Auto FE loader problem with an adp

[AkAlan via AccessMonster.com]

I got the Auto FE loader to work fine with an mdb but when I replace it with
an adp I get the following error: Any ideas? Thanks.

1019 - The following error occurred while attempting to determine the
Access/Jet version of the file 'c:\FrontEnd\QC1.adp' (while using DAO Version
1.20)

Error: 3343 Unrecognized database format 'c:\FrontEnd\QC1.adp'.

---------- H:\Development Stuff\Access Stuff\FE.ini--------------------
[Settings]
MainApp=%APPDATA%\Users\alan.fisher\Desktop\QC1.adp
Server=c:\FrontEnd
CommandLine=/runtime
StartMethod=AutoSelect

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

ShortCutName=QC1
CreateShortCutOnDesktop=Yes
CreateShortCutOnCommonDesktop=No
;ServerShortCutName=Server Shortcut Name
;ShortCutIconFileIndex=27
;ShortCutIconFile=Q:\1 vb\StartMDB\Shell\shell32.dll
;ShortCutCMDFileName=Testing
;ShortCutBATFileName=Testing
;QuickLaunchShortCutName=Testing QL

Shell=C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE
;LauncherEXEPath=Q:\1_vb\StartMDB


------------------------------------------------------------------------------

 

[AkAlan via AccessMonster.com]

OK, Found the solution. I had to change the .ini file and set the StartMethod
to file path and supply the path to MSACCESS.exe in the shell line. Works
great! Thanks Tony. My .ini now looks like this:

[Settings]
MainApp=%APPDATA%\Users\alan.fisher\Desktop\qc1.adp
Server=H:\DatabaseFrontEnd
CommandLine=/runtime
StartMethod=filepath

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

ShortCutName=QC1
CreateShortCutOnDesktop=Yes
CreateShortCutOnCommonDesktop=No
;ServerShortCutName=Server Shortcut Name
;ShortCutIconFileIndex=27
;ShortCutIconFile=Q:\1 vb\StartMDB\Shell\shell32.dll
;ShortCutCMDFileName=Testing
;ShortCutBATFileName=Testing
;QuickLaunchShortCutName=Testing QL

Shell=C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE
;LauncherEXEPath=Q:\1_vb\StartMDB

I got the Auto FE loader to work fine with an mdb but when I replace it with
an adp I get the following error: Any ideas? Thanks.

1019 - The following error occurred while attempting to determine the
Access/Jet version of the file 'c:\FrontEnd\QC1.adp' (while using DAO Version
1.20)

Error: 3343 Unrecognized database format 'c:\FrontEnd\QC1.adp'.

---------- H:\Development Stuff\Access Stuff\FE.ini--------------------
[Settings]
MainApp=%APPDATA%\Users\alan.fisher\Desktop\QC1.adp
Server=c:\FrontEnd
CommandLine=/runtime
StartMethod=AutoSelect

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

ShortCutName=QC1
CreateShortCutOnDesktop=Yes
CreateShortCutOnCommonDesktop=No
;ServerShortCutName=Server Shortcut Name
;ShortCutIconFileIndex=27
;ShortCutIconFile=Q:\1 vb\StartMDB\Shell\shell32.dll
;ShortCutCMDFileName=Testing
;ShortCutBATFileName=Testing
;QuickLaunchShortCutName=Testing QL

Shell=C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE
;LauncherEXEPath=Q:\1_vb\StartMDB

------------------------------------------------------------------------------
--
Auto FE Updater Version: 1.74.0
Windows Version: Windows Vista 6.0 build 6001 (Service Pack 1)
User: alan.fisher
Workstn: ARS-IT-AF-DT

 

[Tony Toews [MVP]]

OK, Found the solution. I had to change the .ini file and set the StartMethod
to file path and supply the path to MSACCESS.exe in the shell line. Works
great! Thanks Tony.

Glad to hear you solved the problem.

Hmm, I should put some logic in there that checks for ADP/ADE file
extension and gives the above instructions.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/