#MICROSOFT ACCESS DATABASE SETUP DRIVER#

#MICROSOFT ACCESS DATABASE SETUP DRIVER#

This value is initially set to 'Yes', which means that the Microsoft Access driver will wait for commits in an internal/implicit transaction to be completed. To set this option dynamically, use the EXCLUSIVE keyword in a call to SQLConfigDataSource.Дetermines how changes made outside of a transaction are written to the database. Performance is enhanced when running in Exclusive mode. If the Exclusive box is selected, the database will be opened in Exclusive mode and can be accessed by only one user at a time. To set this option dynamically, use the DESCRIPTION keyword in a call to SQLConfigDataSource. To set this option dynamically, use the DBQ keyword in a call to SQLConfigDataSource.ДЄn optional description of the data in the data source for example, 'Hire date, salary history, and current review of all employees.' If no database is provided upon setup, the user will be prompted to choose a database file when connecting to the data source. To set this option dynamically, use the DSN keyword in a call to SQLConfigDataSource.ДЄ Microsoft Access data source can be set up without selecting or creating a database.

To set this option dynamically, use the MAXBUFFERSIZE keyword in a call to SQLConfigDataSource.ДЄ name that identifies the data source, such as Payroll or Personnel. Any integer value divisible by 256 can be entered. The default buffer size is 2048 KB (displayed as 2048). The size of the internal buffer, in kilobytes, that is used by Microsoft Access to transfer data to and from the disk.

Microsoft access database setup