Database Interface The Connection tab of the property sheet is displayed: Specifying the location of the file 4. In the Data Source text box, type the complete file path for your ACCDB file. Although the file can be located anywhere on your computer or network, it may be useful to keep it in your project folder. For example: C:\Users\ username \My Documents\InduSoft Web Studio v7.0 Projects \ project_name \Database1.accdb If you do this, however, then you must update the file path whenever you move the project folder. 5. Specify the User name and Password , if any, for the ACCDB file. 6. Click Test Connection . 7.
Click OK to save your changes and return to the Database Configuration property sheet. If a connection can be successfully established, then an appropriate message is displayed. Note: Be sure to select (check) the Disable Primary Keys option in the Database Configuration dialog. If you do not, then IWS will not be able to connect to your Access database Important: Desktop office applications such as Microsoft Access and Microsoft Excel cannot efficiently handle large amounts of data. If you try to save all of your project's historical data in an Access database or Excel spreadsheet, then the queries will become slow and you might get unexpected results.
Therefore, we recommend that Access or Excel be used only as a Secondary Database, with the Store and Forward option enabled, or to relay data to third-party software. To handle large amounts of historical data, we recommend that you use either IWS's proprietary format or a dedicated relational database such as Microsoft SQL Server or ORACLE. Using SQL Server CE IWS projects running in CEView can interface with Microsoft SQL Server CE (SQL CE) databases on the same device by using the OLEDB Provider for SQL Server CE. This provider must be installed on your Windows Embedded device.
Because the provider is only installed on the device and not on your development workstation, you cannot select it in the Data Link Properties dialog when you develop your project. Instead, you must manually enter the connection string using the following format: Page 420 InduSoft Web Studio Version Connection String SQL CE 2.0 Provider=SQLCE; Data Source=database path _