Linton-Sage
Jump to CustomersLinton > Linton > Sage
Sage
Activation codes
- Serial: i298613
- Original activation code: jczitex (licensed for 2 companies)
- Replacement activation code: AABMBCQ (licensed for 4 companies)
- To switch the code go to Tools / Upgrade Program
Update in April 2019
Change licence for 20 users and 25 companies
- Account number is 50512600 (may be linked to Dayta Design)
- Serial: C110228
- Activation key: HWCUQUT
Logging in
- username: manager
- password: <blank>
DDL reports
- Need the database paths set using ODBCAD32.exe
- If 64bit Windows you have to run it from SysWOW64
@echo off
reg query HKLM\Hardware\Description\System\CentralProcessor\0 /c /f "x86" > nul:
If %ERRORLEVEL% == 0 (
echo System is 32bit
pushd %WINDIR%\System32
) else (
echo System is 64bit
pushd %WINDIR%\SysWOW64
)
odbcconf.exe /a {CONFIGSYSDSN "Sage Line 50 v25" "DSN=AcademySage|DATAPATHNAME=\\resources\apps$\Sage\COMPANY.006\ACCDATA"}
odbcconf.exe /a {CONFIGSYSDSN "Sage Line 50 v25" "DSN=AcademySageMeadow|DATAPATHNAME=\\resources\apps$\Sage\COMPANY.008\ACCDATA"}
odbcconf.exe /a {CONFIGSYSDSN "Sage Line 50 v25" "DSN=AcademySageLHJS|DATAPATHNAME=\\resources\apps$\Sage\COMPANY.007\ACCDATA"}
odbcconf.exe /a {CONFIGSYSDSN "Sage Line 50 v25" "DSN=AcademySageCHET|DATAPATHNAME=\\resources\apps$\Sage\COMPANY.011\ACCDATA"}
odbcconf.exe /a {CONFIGSYSDSN "Sage Line 50 v25" "DSN=AcademySageTPPS|DATAPATHNAME=\\resources\apps$\Sage\COMPANY.010\ACCDATA"}
odbcconf.exe /a {CONFIGSYSDSN "Sage Line 50 v25" "DSN=AcademySageHCPS|DATAPATHNAME=\\resources\apps$\Sage\COMPANY.009\ACCDATA"}
popd
reg query HKLM\Hardware\Description\System\CentralProcessor\0 /c /f "x86" > nul:
If %ERRORLEVEL% == 0 (
echo System is 32bit
pushd %WINDIR%\System32
) else (
echo System is 64bit
pushd %WINDIR%\SysWOW64
)
odbcconf.exe /a {CONFIGSYSDSN "Sage Line 50 v25" "DSN=AcademySage|DATAPATHNAME=\\resources\apps$\Sage\COMPANY.006\ACCDATA"}
odbcconf.exe /a {CONFIGSYSDSN "Sage Line 50 v25" "DSN=AcademySageMeadow|DATAPATHNAME=\\resources\apps$\Sage\COMPANY.008\ACCDATA"}
odbcconf.exe /a {CONFIGSYSDSN "Sage Line 50 v25" "DSN=AcademySageLHJS|DATAPATHNAME=\\resources\apps$\Sage\COMPANY.007\ACCDATA"}
odbcconf.exe /a {CONFIGSYSDSN "Sage Line 50 v25" "DSN=AcademySageCHET|DATAPATHNAME=\\resources\apps$\Sage\COMPANY.011\ACCDATA"}
odbcconf.exe /a {CONFIGSYSDSN "Sage Line 50 v25" "DSN=AcademySageTPPS|DATAPATHNAME=\\resources\apps$\Sage\COMPANY.010\ACCDATA"}
odbcconf.exe /a {CONFIGSYSDSN "Sage Line 50 v25" "DSN=AcademySageHCPS|DATAPATHNAME=\\resources\apps$\Sage\COMPANY.009\ACCDATA"}
popd
- Make shortcuts to any Access runtime files
dir /b \\resources\apps$\Sage\DDL\*.accdr
AcademyReportsChilford.accdr
AcademyReportsLHJS.accdr
LVCAcademyPrograms.accdr
Meadow Academy Reports.accdr
AcademyReportsChilford.accdr
AcademyReportsLHJS.accdr
LVCAcademyPrograms.accdr
Meadow Academy Reports.accdr
- If the configuration for the access database doesn't exist, it should prompt you for a database path and then write that to an ini file in the same folder
findstr /e /i accdb \\resources\apps$\Sage\DDL\*.ini
\\resources\apps$\Sage\DDL\AcademyReportsChilford.ini:\\resources\apps$\Sage\DDL\AcademyDataChilford.accdb
\\resources\apps$\Sage\DDL\AcademyReportsLHJS.ini:\\resources\apps$\Sage\DDL\AcademyDataLintonHeights.accdb
\\resources\apps$\Sage\DDL\LVCAcademyPrograms.ini:\\resources\apps$\Sage\DDL\AcademyDataLinton.accdb
\\resources\apps$\Sage\DDL\Meadow Academy Reports.ini:\\resources\apps$\Sage\DDL\AcademyDataMeadow.accdb
\\resources\apps$\Sage\DDL\AcademyReportsChilford.ini:\\resources\apps$\Sage\DDL\AcademyDataChilford.accdb
\\resources\apps$\Sage\DDL\AcademyReportsLHJS.ini:\\resources\apps$\Sage\DDL\AcademyDataLintonHeights.accdb
\\resources\apps$\Sage\DDL\LVCAcademyPrograms.ini:\\resources\apps$\Sage\DDL\AcademyDataLinton.accdb
\\resources\apps$\Sage\DDL\Meadow Academy Reports.ini:\\resources\apps$\Sage\DDL\AcademyDataMeadow.accdb