Access - data provider not initialized?
I have used Access 2003 to develop an interface for a SQL Server database. Since the system was meant to use different schemas to partition the table data, the access project did not work. So I'm forced to use connection management for access instead - I maintain a global connection object and assign records to forms, not sources.
One problem arises: every time someone tries to use a built-in accessor that interacts with a recordset, the operation does not work, and a dialog box is displayed with the message "The data provider could not be initialized." I've done some research and couldn't find an appropriate reason for this, but I suspect it's because Access expects the form to have the correct recordource property and doesn't actually work with assigned recordsets.
Can anyone shed some light on this one? Is there a way to use self-checking recordsets and use built-in functions? Can anyone confirm that this is an access error?
a source to share
After playing some games, I found a partial solution. I used client side cursors but left recordsets associated with them. Instead of disabling recordsets, the data provider messages are gone. Of course it caused other problems, but this is a different story ... and of course I still don't understand WHY this makes a difference ... anyone else?
a source to share