Microsoft KB Archive/229741

= BUG: Connection Failure with ADO 2.1 and the Jet 3.51 Provider =

Article ID: 229741

Article Last Modified on 7/28/2003

-

APPLIES TO


 * Microsoft ActiveX Data Objects 2.1
 * Microsoft ActiveX Data Objects 2.5
 * Microsoft OLE DB Provider for Jet 3.51

-



This article was previously published under Q229741



SYMPTOMS
If you try to set read, write, or read/write access permissions using the ADO mode property within your connection string, you receive the following error:

Run-time error: '-2147217887' "Errors Occurred"

However, if you use the Microsoft Data Link or the Data Environment designer to set these permissions, you get the following error:

Test connection failed because of an error in

initializing provider. 0x80040e21



RESOLUTION
Remove the "Share Deny None" mode option from your ADO connection string.

If you are using the Microsoft Data Link or the Data Environment designer, you can deselect the "Share Deny None" option from the Advanced tab.

-or-

Use the Jet 4.0 OLE DB Provider instead of the Jet 3.51 OLE DB Provider.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce Behavior

 * 1) Right-click on your Desktop, choose New/Microsoft Data Link.
 * 2) Fill in the appropriate information to connect to your Access Database via the Microsoft Jet 3.51 OLEDB Provider.
 * 3) Go to the Advanced tab. Select read, write, or read/write permission.
 * 4) Test your connection. You should get the error.

