What are the possible MODE for Provider=Microsoft.ACE.OLEDB.12.0

Harold Dolman 26 Reputation points
2021-01-27T15:58:09.997+00:00

What are all the possibilities for MODE for Provider=Microsoft.ACE.OLEDB.12.0 and what do they mean ?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,646 questions
0 comments
Accepted answer
  1. HansV 946 Reputation points MVP
    2021-01-28T08:04:27.937+00:00

    Microsoft does a bad job documenting this. I think the possible settings are as follows, but I'm not sure:

    • Read — Read only.
    • ReadWrite — Read and write.
    • Share Deny None — Neither read nor write access can be denied to others.
    • Share Deny Read — Prevents others from opening in read mode.
    • Share Deny Write — Prevents others from opening in write mode.
    • Share Exclusive — Prevents others from opening in read/write mode.
    • Write — Write only.
    1 person found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 946 Reputation points MVP
    2021-01-27T20:07:21.027+00:00

    www.connectionstrings.com lists all connection strings you can think of. See the section for Access in particular.

    1 person found this answer helpful.
  2. Harold Dolman 26 Reputation points
    2021-02-01T11:07:13.667+00:00

    Thanks again ... much appreciated ...

    1 person found this answer helpful.
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more