Appendix c: compact workstation utility, Appendix d: manual iis setup, Appendix e: checking iis setup – IntelliTrack Check In/Out User Manual

Page 18: Appendix f: microsoft access integration

Advertising
background image

I

NTELLI

T

RACK

C

HECK

I

N

-O

UT

V

8.1

User Manual

xviii

xviii

Database Backup and Restore with SQL Server/SQL Express ........................ 419

Database Backup with SQL Server Management Studio .......................... 419
Database Restore with SQL Server Management Studio .......................... 427

IntelliTrack Backup and Restore Database Utilities ........................................ 435

Batch Utilities ............................................................................................ 435
Databackup Folder Permissions................................................................. 437

APPENDIX C: Compact Workstation Utility ......................................443

Overview .................................................................................................................. 444
Compacting the Workstation Application File......................................................... 444

APPENDIX D: Manual IIS Setup .......................................................445

Overview .................................................................................................................. 446
Manual IIS RDA Setup Requirements ..................................................................... 446

Manually Configuring IIS on Windows XP or

Windows Server 2003 Operating Systems........................................................ 447
Setting up IIS v6.0 to Allow the DMS Web Service Extension........................ 448
Manually Configuring IIS on Windows Vista /Windows 7/ Windows Server 2008
Operating Systems ............................................................................................ 450
Setting Up IIS v7.0 to Allow the DMS Web Service Extension....................... 451
Configuring the IntelliTrack Application Pool ................................................. 458

APPENDIX E: Checking IIS Setup ....................................................463

Overview .................................................................................................................. 464
Reaching the Batch Synchronization Utility............................................................ 464

Sync URL Setting ............................................................................................. 465

APPENDIX F: Microsoft Access Integration .....................................469

Introduction .............................................................................................................. 470
Full Access Import ................................................................................................... 470
Import Access Inventory Data.................................................................................. 471

Query Import Data – Site Table ........................................................................ 474
Query Import Data – Bin Location Table ......................................................... 474
Query Import Data – Inventory Table............................................................... 475
Query Import Data – TblCheck Table............................................................... 476
Query Import Data – Inventory by Location Table........................................... 477

Exporting Data ......................................................................................................... 478
Custom Reports ........................................................................................................ 478

2283.book Page xviii Thursday, July 7, 2011 2:29 PM

Advertising