13 DATABASE FUNCTION
13.3 CPU Module Database Access (from External Device) Function
251
13
Record operation from an application
The following provides an example of record operation such as synchronizing, writing, and deleting of the data by connecting
to the database of the CPU module by using Microsoft Access.
1.
Start Microsoft Access and select the [External Data] tab
[ODBC Database].
2.
When the window to select the method for storing the
data in the database, select "Link to the data source by
creating a linked table", and click the [OK] button.
3.
On the window for selecting the data source, click the
[Machine Data Source] tab and select the data source of
the CPU module.
• When the default user is not set to the ODBC data source, input the user
name and password.
• When no data source of the CPU module is displayed in the window, add a
database of the CPU module to the ODBC data source. (
Adding a database to the ODBC data source)
Ethernet
Содержание MELSEC iQ-R-R00CPU
Страница 2: ......
Страница 151: ...9 MONITOR FUNCTION 9 1 Real Time Monitor Function 149 9 MEMO ...
Страница 323: ...18 SEQUENCE SCAN SYNCHRONIZATION SAMPLING FUNCTION 321 18 MEMO ...
Страница 330: ...328 20 ROUTING SETTING 20 3 Precautions MEMO ...
Страница 423: ...26 BASIC CONCEPT 26 8 State Transition of the Redundant System 421 26 MEMO ...
Страница 524: ...522 30 MAINTENANCE AND INSPECTION FOR A REDUNDANT SYSTEM 30 1 Module Replacement in the Redundant System MEMO ...
Страница 1009: ...APPX Appendix 14 List of Available SQL Commands for CPU Module Database Access Function 1007 A MEMO ...
Страница 1014: ...1012 APPX Appendix 15 Added and Enhanced Functions MEMO ...
Страница 1027: ......