Note You can link a table only in a Microsoft Access database, not a Microsoft Access project.
If you are administering an SQL database that uses Microsoft Access as a front end, then you can create a table in your SQL database named MSysConf to help you control communication between the two applications. The MSysConf table has two potential functions:
The SQL database table MSysConf should have the following structure.
Column name | Data type | Allows Null? |
---|---|---|
Config | A data type that corresponds to a 2-byte integer | No |
chValue | VARCHAR(255) | Yes |
nValue | A data type that corresponds to a 4-byte integer | Yes |
Comments | VARCHAR(255) | Yes |
Note If the data source you're working with is case-sensitive, then use the table and column names exactly as shown.
All users must have permission to use the Select statement on this table, and only the system administrator should have insert/update/delete permission.
There are three valid records in the MSysConf table. The following table shows what values you should enter in the Config and nValue field. The other columns are reserved for future use, and their contents are ignored.
Config | nValue | Meaning |
---|---|---|
101 | 0 | Don't allow local storage of the logon ID and password in linked tables. |
101 | 1 | Allow local storage of the logon ID and password in linked tables. |
102 | D | D is the delay in seconds between each retrieval. |
103 | N | N is the number of rows retrieved. |
Notes