BUG: Connection Failure with ADO 2.1 and the Jet 3.51 Provider (229741)

The information in this article applies to:

ActiveX Data Objects (ADO) 2.1
ActiveX Data Objects (ADO) 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.

MORE INFORMATION

Steps to Reproduce Behavior

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

REFERENCES

For more information, please refer to the ADO documentation.

Modification Type:	Minor	Last Reviewed:	7/28/2003
Keywords:	kbBug kbDatabase kbDataEnv kbDataview kbMDACNoSweep kbpending KB229741