Cannot access LANPAK.BIN in the SITE directory 1

[wysiwygger]

Hi,

I'm running SQL Server 2005 on Windows Server 2003.

Accpac is running on version 5.4 with the latest service packs.
I don't usually run Accpac on the server, I just connect to it from the workstation. However today I tried to run it on the server and received the following error when trying to log in:

Cannot access LANPAK.BIN in the SITE directory.

Make sure that the ShareDdata entry in the Windows Registry specified the drive and directory containing the SITE, USER and COMPANY subdirectories and that you have read/write/create access.

I've checked through the Registry entry : the SharedData value is the path to my Data folder. In in are the Site, User and Company folder. All permissions are set.

I cant figure out what's gone wrong. I know it used to work but can't tell when it stopped. Access from the workstations is still fine.

 

[DjangMan]

What does your registry say for the Program Directory and Shared Data Directory?

 

[wysiwygger]

SharedData:
D:\Program Files\ACCPAC\Data
This where the site folder is.

Program:
D:\Program Files\ACCPAC

 

[DjangMan]

When you've been trying have other users been in Accpac at the same time?

 

[wysiwygger]

I tried with and without other users being in Accpac.
Same result.

 

[DjangMan]

I think I've run out of straws. Normally the next process would be to connect to your server and look myself.

Oh - one more straw - but it is a short one. Try running the regacc application in the RUNTIME folder. See if it encounters any errors in the log file that it generates or if the issue is resolved once regacc has finished registering all the applications.

 

[ettienne]

Change
SharedData: D:\Program Files\ACCPAC\Data

to
SharedData: D:\Program Files\ACCPAC

and see if that works.

The Site folder may not be where the think it is....

 

[DjangMan]

Along those same lines: What does the registry say for shareddata and program files on the workstations?

 

[wysiwygger]

registry on workstation says the following:

shareddata: \\server\accpac\data
programs: \\server\accpac

Accpac is a shared folder with full permission to users

 

[DjangMan]

Did running regacc on the server fix anything or report any errors?

 

[wysiwygger]

Ran regacc just now, but it still fails.
;(

 

[DjangMan]

Does the regacc log show errors?

There's another program called System Diagnostic under the Accpac Tools menu (start, programs, ...). Post the results here.

 

[wysiwygger]

Hi,

regacc doesn't show any relevant error. Below is the only error that showed up, but we are using PJC 5.4:
DllRegisterServer for D:\Program Files\ACCPAC\PM53B\PJCDataWizard.dll failed and returned -2147467259

Output of System Diagnostic see below:

Sage Accpac Diagnostic Output 05/16/08 20:29:34

ACCPAC for Windows Registry Settings

HKEY_LOCAL_MACHINE\Software\ACCPAC INTERNATIONAL, INC.
ACCPAC
Configuration
Programs = D:\Program Files\ACCPAC
SharedData = D:\Program Files\ACCPAC\Data
AppDistPath = D:\Program Files\ACCPAC\web\cabs

WebReportPath = D:\Program Files\ACCPAC\web\reports
WebReportURL =
CEName = server.domain.COM
CEUser = Administrator
CEFolder = Accpac
ESConfig = 2
RemotingChannel = 1
UseRAS = 0
WebBaseURL = 0
RemotingMaxDesktops = 1
RemotingMaxProcsPerDesktop = 1
ProgramFolder = Sage Accpac
Debug
AltMem = No
ViewDefer = YES
ErrorLogFile =
Extract
DataSets = \\server\backups\accpac\accpac
Registration
ExpireInDays = 0
Contact = Employee Of
Company Name = Company
Dealer Name = Dealer
CC Name =
SM51A = 8004240-33750
GL51A = 8004030-37154
AR51A = 8004060-37154
AP51A = 8004090-37154
IC51A = 8004120-42181
OE51A = 8004150-37181
PO51A = 8004100-42182
CS51A = 8004610-33018
OB51A = 8004PT0-33017
QI Name =
SN43A = 1003SN0-23098
LP51A = 800441044258
SG51A = 1003670-22275
SN51A = 000000000000
SM53A = 7104240-1015911
SM53B = 7104240-1015911
CS53A = 7104610-1005915
LP53A = 8407400-1009951
TL53A = 8004T10-1004782
OB53A = 7104PT0-1005907
GL53B = 7104030-1015751
AR53A = 7104060-1006013
AP53A = 7104090-1006402
IC53A = 7104120-1003684
OE53A = 7104150-1003595
PM53B = 8004210-1002086
SN53B = 1103SN0-1000054
Status = 0
PO53B = 7104100-1006956
EB51A = 105110300178
SM54A = 7104240-1023547
CS54A = 7104610-1012198
OB54A = 7104PT0-1013152
LP54A = 7107400-1009600
TL54A = 7104T10-1000325
AP54A = 7104090-1016241
GL54A = 7104030-1023482
AR54A = 7104060-1013769
IC54A = 7104120-1012119
PO54A = 7104100-1010081
PM54A = 7104210-1004736
SG54A = 1103670-30436
ROTO
Standalone = Yes
WEB
A4WOSSUP = 1
ACCPAC Account Code Change 5.1A
5.10.000
5.15.000
Sage Accpac System Manager 5.3B
5.3.001
System Manager Service Pack 3
5.1A

Btrieve Win32 Registry Settings

HKEY_LOCAL_MACHINE\SOFTWARE\Btrieve Technologies

*****************************************************************

Contents of C:\AUTOEXEC.BAT:


*****************************************************************

Contents of C:\CONFIG.SYS:


*****************************************************************

Contents of C:\WINDOWS\WINSTART.BAT:


*****************************************************************

Contents of D:\Program Files\ACCPAC\RUNTIME\A4W.INI:


[Defaults]
language=ENG
save settings=yes
auto clear=no
confirm on delete=yes
confirm on print=yes
confirm on close=no
view=ICON
caret directory=caret
use report orientation=yes
use report paper size=yes

[FileFormats]
CSV=A4WXCSV,Comma Separated Values,CSV,TRUE,3
Excel=A4WXXCEL,Excel,XLS,TRUE,3
Pipe=A4WXPIP,Pipe Delimited Values,PIP,TRUE,3
SuperCalc=A4WXCAL,SuperCalc,CAL,TRUE,3
Lotus 123=A4WX123,Lotus 1-2-3,WKS,TRUE,3
dBase III=A4WXDB3,dBase III/III+,DBF,FALSE,1
DIF=A4WXDIF,Data Interchange Format,DIF,FALSE,1
dBase II=A4WXDB2,dBase II,DB2,FALSE,1
Continuous=A4WXCON,Continuous,CON,FALSE,4
Sylk=A4WXSLK,Symbolic Link,SLK,TRUE,3
SCW=A4WXSCW,SuperCalc/Windows,MDS,TRUE,3

[Object Classes]
BATCH=3,batch,header,detail
FLAT=1,object
ORDERED=2,header,detail
SEQUENCE=2,header,detail
SET=1,set
SUPER=1,object
ORD2=3,header,detail1,detail2
ORD3=4,header,detail1,detail2,detail3
ORD4=5,header,detail1,detail2,detail3,detail4
ORD5=6,header,detail1,detail2,detail3,detail4,detail5
ORD6=7,header,detail1,detail2,detail3,detail4,detail5,detail6
ORD7=8,header,detail1,detail2,detail3,detail4,detail5,detail6,detail7
ORD8=9,header,detail1,detail2,detail3,detail4,detail5,detail6,detail7,detail8
ORD9=10,header,detail1,detail2,detail3,detail4,detail5,detail6,detail7,detail8,detail9
ORD10=11,header,detail1,detail2,detail3,detail4,detail5,detail6,detail7,detail8,detail9,detail10
SEQ2=3,header,detail1,detail2
SEQ3=4,header,detail1,detail2,detail3
SEQ4=5,header,detail1,detail2,detail3,detail4
SEQ5=6,header,detail1,detail2,detail3,detail4,detail5
SEQ6=7,header,detail1,detail2,detail3,detail4,detail5,detail6
SEQ7=8,header,detail1,detail2,detail3,detail4,detail5,detail6,detail7
SEQ8=9,header,detail1,detail2,detail3,detail4,detail5,detail6,detail7,detail8
SEQ9=10,header,detail1,detail2,detail3,detail4,detail5,detail6,detail7,detail8,detail9
SEQ10=11,header,detail1,detail2,detail3,detail4,detail5,detail6,detail7,detail8,detail9,detail10
SEQ11=12,header,detail1,detail2,detail3,detail4,detail5,detail6,detail7,detail8,detail9,detail10,detail11
SEQ12=13,header,detail1,detail2,detail3,detail4,detail5,detail6,detail7,detail8,detail9,detail10,detail11,detail12
SEQ13=14,header,detail1,detail2,detail3,detail4,detail5,detail6,detail7,detail8,detail9,detail10,detail11,detail12,detail13
SEQ14=15,header,detail1,detail2,detail3,detail4,detail5,detail6,detail7,detail8,detail9,detail10,detail11,detail12,detail13,detail14
SEQ15=16,header,detail1,detail2,detail3,detail4,detail5,detail6,detail7,detail8,detail9,detail10,detail11,detail12,detail13,detail14,detail15
BATCH2=4,batch,header,detail1,detail2
BATCH3=5,batch,header,detail1,detail2,detail3
BATCH4=6,batch,header,detail1,detail2,detail3,detail4
BATCH5=7,batch,header,detail1,detail2,detail3,detail4,detail5
BATCH6=8,batch,header,detail1,detail2,detail3,detail4,detail5,detail6
BATCH7=9,batch,header,detail1,detail2,detail3,detail4,detail5,detail6,detail7
BATCH8=10,batch,header,detail1,detail2,detail3,detail4,detail5,detail6,detail7,detail8
BATCH9=11,batch,header,detail1,detail2,detail3,detail4,detail5,detail6,detail7,detail8,detail9
BATCH10=12,batch,header,detail1,detail2,detail3,detail4,detail5,detail6,detail7,detail8,detail9,detail10
DETAIL=2,header,detail
ARBATCH1=5,batch,header,detail1,detail2,detail3
ARBATCH2=4,batch,header,detail1,detail2


[ImportExport]
BATCH=A4WXBAT.DLL,0,1,1
FLAT=A4WXFLT.DLL,1
ORDERED=A4WXORD.DLL,1,1
SEQUENCE=A4WXSEQ.DLL,1,1
SET=A4WXSET.DLL,1
ORD2=A4WXORD.DLL,1,1,1
ORD3=A4WXORD.DLL,1,1,1,1
ORD4=A4WXORD.DLL,1,1,1,1,1
ORD5=A4WXORD.DLL,1,1,1,1,1,1
ORD6=A4WXORD.DLL,1,1,1,1,1,1,1
ORD7=A4WXORD.DLL,1,1,1,1,1,1,1,1
ORD8=A4WXORD.DLL,1,1,1,1,1,1,1,1,1
SEQ2=A4WXSEQ.DLL,1,1,1
SEQ3=A4WXSEQ.DLL,1,1,1,1
SEQ4=A4WXSEQ.DLL,1,1,1,1,1
SEQ5=A4WXSEQ.DLL,1,1,1,1,1,1
SEQ6=A4WXSEQ.DLL,1,1,1,1,1,1,1
SEQ7=A4WXSEQ.DLL,1,1,1,1,1,1,1,1
SEQ8=A4WXSEQ.DLL,1,1,1,1,1,1,1,1,1
BATCH2=A4WXBAT.DLL,0,1,1,1
BATCH3=A4WXBAT.DLL,0,1,1,1,1
BATCH4=A4WXBAT.DLL,0,1,1,1,1,1
BATCH5=A4WXBAT.DLL,0,1,1,1,1,1,1
BATCH6=A4WXBAT.DLL,0,1,1,1,1,1,1,1
BATCH7=A4WXBAT.DLL,0,1,1,1,1,1,1,1,1
BATCH8=A4WXBAT.DLL,0,1,1,1,1,1,1,1,1,1
DETAIL=A4WXDTL.DLL,0,1
ARBATCH1=A4WXARC.DLL,0,1,1,1,1
ARBATCH2=A4WXARC.DLL,0,1,1,1

[Database Drivers]
0=Pervasive.SQL,A4WBTRV.DLL,A4WDBTRV.DLL
2=Microsoft SQL Server,A4WSQLS.DLL,A4WDSQLS.DLL
3=IBM DB2,A4WDB2.DLL,A4WDDB2.DLL
4=Oracle,A4WORCL.DLL,A4WDORCL.DLL

[A4WBTRV]
LockRetryTimeout=2000
LockRetryPrompt=No

[A4WSQLS]
LockRetryTimeout=4000
LockRetryPrompt=No
Log=2
CursorType=3
QueryTimeout=0

[Languages]
ENG=English

[Configuration]
Logo=A4WLOGO.DLL
Region=2
[General]
PTF20070901=1
ServicePack=3

*****************************************************************

Contents of D:\Program Files\ACCPAC\RUNTIME\LANGUAGE.INI:

[ENG]
ENG=English
FRA=French
ESN=Spanish
CHN=Chinese (Simplified)
CHT=Chinese (Traditional)
ARB=Arabic

[FRA]
ENG=Anglais
FRA=Français
ESN=Espagnol
CHN=Chinois simplifié
CHT=Chinois traditionnel
ARB=Arabe

[ESN]
ENG=Inglés
FRA=Francés
ESN=Español
CHN=Chino Simplificado
CHT=Chino Tradicional
ARB=Árabe

[CHN]
ENG=Ó¢ÎÄ
FRA=·¨ÎÄ
ESN=Î÷°àÑÀÎÄ
CHN=¼òÌåÖÐÎÄ
CHT=·±ÌåÖÐÎÄ
ARB=°¢À­²®ÎÄ

[CHT]
ENG=­^¤å
FRA=ªk¤å
ESN=¦è¯Z¤ú¤å
CHN=²Å餤¤å
CHT=ÁcÅ餤¤å
ARB=ªü©Ô§B¤å

[ARB]
ENG=ÇáÇäÌáíÒíÉ
FRA=ÇáÝÑäÓíÉ
ESN=ÇáÇÓÈÇäíÉ
CHN=ÇáÕíäíÉ ÇáÈÓíØÉ
CHT=ÇáÕíäíÉ ÇáÊÞáíÏíÉ
ARB=ÇáÚÑÈíÉ

*****************************************************************

Directory Listing of D:\Program Files\ACCPAC:

. 2007/11/16 09:40:53 <DIR>
.. 2007/11/16 09:40:53 <DIR>
3rdparty 2005/08/03 12:07:56 <DIR>
Accpac Reports 2005/03/08 14:52:35 <DIR>
AccpacWebServic 2006/11/20 22:42:12 <DIR>
AOSMTP 2008/04/29 17:06:18 <DIR>
AP53A 2007/10/13 21:03:50 <DIR>
AP54A 2007/11/16 09:39:15 <DIR>
AR53A 2007/10/13 21:04:13 <DIR>
AR54A 2007/11/16 09:39:47 <DIR>
as53A 2006/11/20 20:41:50 <DIR>
as54A 2007/11/16 09:41:56 <DIR>
ASP 2004/02/10 09:41:49 <DIR>
BACKUP 2006/05/13 19:34:18 <DIR>
bk53A 2006/04/20 17:26:12 <DIR>
bk54A 2007/11/16 09:41:56 <DIR>
BMP 2007/11/16 09:16:36 <DIR>
COMPANY 2006/04/10 12:56:18 <DIR>
cs53A 2006/11/20 20:44:28 <DIR>
cs54A 2007/11/16 09:41:55 <DIR>
CSAPP.DAT 2004/06/25 11:46:49 024576 bytes
DATA 2007/11/16 10:47:09 <DIR>
DATADICT.DAT 2004/06/25 11:46:50 009216 bytes
Directory Listi 2006/06/06 15:29:51 <DIR>
DOCS 2007/11/16 10:49:21 <DIR>
Document templa 2006/06/06 15:31:25 <DIR>
EB51A 2007/03/30 09:54:38 <DIR>
ENU 2004/02/10 12:47:38 <DIR>
ERRORS.LOG 2006/04/06 16:34:18 038161 bytes
extender 2006/11/20 21:05:14 <DIR>
FIDATA 2004/02/18 14:09:36 <DIR>
FIELD.DDF 2004/06/25 11:46:50 019456 bytes
Fiform.zip 2002/12/10 11:24:20 095515 bytes
FILE.DDF 2004/06/25 11:46:49 005120 bytes
FT51A_old 2006/02/07 11:20:03 <DIR>
FT53A 2008/04/29 17:06:19 <DIR>
GL53B 2007/10/13 21:04:35 <DIR>
GL54A 2007/11/16 09:40:09 <DIR>
gp53A 2006/04/07 14:43:11 <DIR>
gp54A 2007/11/16 08:53:26 <DIR>
HELP 2007/11/16 10:49:57 <DIR>
IC53A 2007/10/13 21:03:26 <DIR>
IC54A 2007/11/16 09:40:32 <DIR>
ICONS 2004/02/10 12:47:37 <DIR>
IMAGE 2004/02/10 12:47:37 <DIR>
INDEX.DDF 2004/06/25 11:46:50 008192 bytes
LIC Files 2005/03/21 13:50:32 <DIR>
MACROS 2007/11/16 10:49:21 <DIR>
MSXML Client 2004/02/18 14:13:09 <DIR>
NPADMIN 2006/05/17 12:27:47 <DIR>
NPDATA 2004/02/18 14:12:42 <DIR>
OE53A 2007/10/13 21:05:07 <DIR>
OE54A 2007/11/16 10:50:01 <DIR>
OLDSN51A 2004/05/13 10:09:23 <DIR>
optconv 2007/11/16 10:49:27 <DIR>
Patches 2004/06/25 14:09:53 <DIR>
Path.txt 2004/03/04 15:38:50 000119 bytes
PM53B 2007/10/13 21:05:30 <DIR>
PM54A 2007/11/16 09:41:14 <DIR>
PO53B 2007/10/14 16:23:18 <DIR>
PO54A 2007/11/16 09:41:33 <DIR>
Protokoll.log 2004/06/18 16:17:04 116355 bytes
REPORTS 2005/06/09 14:10:23 <DIR>
RUNTIME 2007/11/16 14:59:48 <DIR>
SEMAPHOR.BIN 2005/04/05 09:27:15 018944 bytes
Service Packs 2006/04/11 09:47:58 <DIR>
SetupWz 2007/11/16 09:41:55 <DIR>
SG51A 2006/04/19 13:17:41 <DIR>
SG51A_old 2005/02/16 09:50:59 <DIR>
SG54A 2007/11/16 09:35:12 <DIR>
SITE 2006/04/08 18:58:15 <DIR>
SN53B 2007/10/13 21:06:12 <DIR>
Temp 2004/09/07 12:01:30 <DIR>
test 2005/03/01 08:23:39 136002 bytes
TRACKER 2004/02/10 12:47:38 <DIR>
Tsheet-Posting. 2005/02/24 09:31:16 043520 bytes
TX51A 2006/04/07 12:16:08 <DIR>
tx53A 2006/04/20 17:26:15 <DIR>
tx54A 2007/11/16 09:41:55 <DIR>
VM CD 2004/09/07 12:07:28 <DIR>
VM5060-wiptot.r 2005/02/23 09:50:26 256000 bytes
VM51A 2006/04/10 12:55:53 <DIR>
VM51A.LICjec 2004/09/07 12:14:38 000764 bytes
WEB 2007/03/30 09:54:38 <DIR>
WINDOWS 2004/02/10 12:41:42 <DIR>
WSSetup 2008/05/01 13:33:57 <DIR>

*****************************************************************

Environment Variable Settings:

ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\Administrator\Application Data
CLASSPATH=D:\PVSW\BIN\psql.jar;D:\PVSW\BIN\PVJDBC2X.JAR;D:\PVSW\BIN\PVJDBC2.JAR;D:\Program Files\VERITAS\Backup Exec\NT\ECM\bumodule.jar;D:\Program Files\VERITAS\Backup Exec\NT\ECM\LOG4J-CORE.JAR;D:\Program Files\VERITAS\Backup Exec\NT\ECM\LOG4J.JAR;.
CLIENTNAME=computer
ClusterLog=C:\WINDOWS\Cluster\cluster.log
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=server
ComSpec=C:\WINDOWS\system32\cmd.exe
DellAgentPath=C:\Program Files\Dell\OpenManage\OMSA\bin
EXCHICONS=D:\Program Files\Exchsrvr\bin\maildsmx.dll
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\Administrator
Isuser=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\{E4AD4FA7-6473-4A3A-9667-93040CDE2E68}\{0F86FD09-BA63-4E45-A70B-604C1106C2F2}\_isuser.dll
lib=C:\Program Files\SQLXML 4.0\bin\
LOGONSERVER=\\server
NUMBER_OF_PROCESSORS=4
OMPATH=C:\Program Files\Dell\OpenManage\oma\bin;C:\Program Files\Dell\OpenManage\LU\bin;C:\Program Files\Dell\OpenManage\oldiags\bin
OS=Windows_NT
Path=D:\Program Files\ACCPAC\RUNTIME;c:\windows\system32;c:\windows;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;D:\Program Files\MySQL\bin
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.VBS
PERVASIVE_PATH=D:\PVSW\BIN
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 15 Model 2 Stepping 9, GenuineIntel
PROCESSOR_LEVEL=15
PROCESSOR_REVISION=0209
ProgramFiles=C:\Program Files
SESSIONNAME=RDP-Tcp#8
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\2
TMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\2
USERDNSDOMAIN=domain.com
USERDOMAIN=domain
USERNAME=administrator
USERPROFILE=C:\Documents and Settings\Administrator
VSL=D:\PVSW\BIN
windir=C:\WINDOWS

*****************************************************************

Drive Mappings:


*****************************************************************

Currently Loaded Modules:

a4wdiag.exe 2006/05/28 12:22:10 40960 d:\program files\accpac\runtime\a4wdiag.exe
ntdll.dll 2005/03/24 20:42:32 766464 c:\windows\system32\ntdll.dll
kernel32.dll 2007/04/19 00:34:08 1038848 c:\windows\system32\kernel32.dll
msvcrt.dll 2005/03/24 18:07:38 348672 c:\windows\system32\msvcrt.dll
advapi32.dll 2005/03/24 17:55:28 620032 c:\windows\system32\advapi32.dll
rpcrt4.dll 2007/07/11 18:43:26 642560 c:\windows\system32\rpcrt4.dll
user32.dll 2007/03/02 14:10:30 588800 c:\windows\system32\user32.dll
gdi32.dll 2008/02/18 21:49:48 284672 c:\windows\system32\gdi32.dll
mpr.dll 2003/03/25 20:00:00 57344 c:\windows\system32\mpr.dll
imm32.dll 2005/03/24 18:05:04 110592 c:\windows\system32\imm32.dll
msctf.dll 2005/03/24 18:07:24 318464 c:\windows\system32\msctf.dll
apphelp.dll 2005/03/24 17:55:28 150016 c:\windows\system32\apphelp.dll
msctfime.ime 2005/03/24 18:07:24 177152 c:\windows\system32\msctfime.ime
ole32.dll 2005/07/21 11:24:20 1245184 c:\windows\system32\ole32.dll
a4wapi.dll 2007/09/28 10:18:26 524288 d:\program files\accpac\runtime\a4wapi.dll
comdlg32.dll 2005/03/24 17:57:56 281088 c:\windows\system32\comdlg32.dll
comctl32.dll 2006/08/28 16:25:50 599040 c:\windows\winsxs\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.3790.2778_x-ww_497c098c\comctl32.dll
shell32.dll 2007/10/26 14:51:31 8383488 c:\windows\system32\shell32.dll
shlwapi.dll 2006/10/24 00:41:11 321536 c:\windows\system32\shlwapi.dll
winspool.drv 2005/03/24 18:26:18 150528 c:\windows\system32\winspool.drv
a4wcompat.dll 2006/05/28 12:14:14 45056 d:\program files\accpac\runtime\a4wcompat.dll
a4wmem32.dll 2007/09/28 10:16:28 2142208 d:\program files\accpac\runtime\a4wmem32.dll
cato3msk.dll 2002/09/24 09:30:30 61481 d:\program files\accpac\runtime\cato3msk.dll
a4wroto.dll 2007/09/28 10:19:44 61485 d:\program files\accpac\runtime\a4wroto.dll
a4wsem.dll 2006/05/28 12:14:44 36864 d:\program files\accpac\runtime\a4wsem.dll
version.dll 2005/03/24 18:26:14 18432 c:\windows\system32\version.dll
oleaut32.dll 2007/12/13 16:14:05 557568 c:\windows\system32\oleaut32.dll
odbc32.dll 2005/03/24 18:08:34 245760 c:\windows\system32\odbc32.dll
comctl32.dll 2006/08/28 16:25:51 1051136 c:\windows\winsxs\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.3790.2778_x-ww_a8f04f11\comctl32.dll
odbcint.dll 2005/03/24 18:08:34 94208 c:\windows\system32\odbcint.dll
cabl3.dll 1999/08/18 13:25:20 646656 d:\program files\accpac\runtime\cabl3.dll
cabl3db1.dll 1995/12/20 02:00:00 38400 d:\program files\accpac\runtime\cabl3db1.dll
msvcrt20.dll 2003/03/25 20:00:00 253952 c:\windows\system32\msvcrt20.dll
psapi.dll 2005/03/24 18:12:26 20480 c:\windows\system32\psapi.dll

*****************************************************************

Databases:

OrgID Description Type SysID Specification
DAT Company 1 DATSYS server\accpac..dat
DATSYS DATSYS Company System database 0 server\accpac..datsys
SAMINC Sample Company Inc. 1 SAMSYS \\server\ACCPAC\data\SAMPLE\SAMINC
SAMLTD Sample Company Ltd. 1 SAMSYS \\server\ACCPAC\data\SAMPLE\SAMLTD
SAMSYS Sample Company System 0 \\server\ACCPAC\data\SAMPLE\SAMSYS
TEST Testcompany 1 TESTSY server\accpac..test
TESTSY TESTSY 0 server\accpac..testsys

 

[DjangMan]

So the only thing that is jumping out at me is that you have UNC for your data paths and drive letters in your registry. Not an unexpected situation for a server. Perhaps try changing your server registry paths to use the UNC paths. (And back up the original.) You won't affect the workstations by doing this.

 

[ettienne]

Another thing to watch for is that the icon you use to start up Accpac must match the registry setting.
For example, if the icon points to D:\Program Files\Accpac\Runtime\accpac.exe then your registry should point to Programs = D:\Program Files\ACCPAC.
If these do not match then you could run into problems.
You do not have to use UNC as suggested, as there is no relationship between where the data is and where the program files are located.
If you are only having problems on the server and not the workstation, then it boils down to permissions on the server.
In 99.999999999999999999% of the time the error you are getting relates to permissions.

 

[wysiwygger]

PROBLEM SOLVED!

OK, I think I solved my problem.
I believe it was related to EFT Services.

I'm currently running EFT 5.3 on Accpac 5.4 but lately I had problems sending remittance advices via email.

So I've been testing with 5.4. Installed the upgrade on my local machine and converted my test database to work with the new version. This must have somehow confused the server installation?
I did not touch the server installation at all.
Every modification I did was on my local machine which has a full Accpac Installation as well but links to the DATA directory on the server.

Now I've upgraded EFT on the server and I could log on to Accpac on the server straight away.

Anybody has an explanation for that!?

Thanks for all your help!

 

[DjangMan]

Evil spirits?

I'm glad it's working.

 

[Jay Converse]

The explanation is that you mixed different programs pointing to the same data. This is why all (competent) Accpac resellers install programs on the server, not on each workstation.