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

ID: Q229741

The information in this article applies to:

ActiveX Data Objects (ADO), version 2.1
Microsoft OLE DB Provider for Jet, version 3.51

SYMPTOMS

If you try to set read, write, or read/write access permissions using the ADO mode property within your connection string, you get the 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 OLEDB Provider instead of the Jet 3.51 OLEDB Provider.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products 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.

Additional query words:

Keywords : kbADO210bug kbDataview kbOLEDB kbDataEnv kbGrpVBDB
Version : WINDOWS:2.1,3.51
Platform : WINDOWS
Issue type : kbbug