I have an ADP - Access 2000 front-end, SQL Server 2000 back-end.
When I sit at our file server and open the ADP, and then open up an Access form called OrderForm, I get the following error: "Data Provider or other service returned an E-FAIL status." When I click "OK" -- the Microsoft "failure acceptance" button that makes everything all better -- most of the form fields are then populated with #Error.
Here's an interesting twist: When the E_FAIL error is encountered on the server, the networked "G" drive, located on the server, becomes unavailable to users elsewhere on the network... Although the "G" drive *is* still available to me, since I'm still at the server itself.
I have no clue why these two occurences are even related. But mainly, I have no clue as to why I am (suddenly) getting the E_FAIL error message to begin with. Can anyone help me? I don't even know what it means. SQL Server is working just fine.