Hi
I'm using VB6 and connecting to an Access2000 database using ADO.
When trying to delete a rocord from a recordset I get the following error message. ".... Insufficient key information for updating or refreshing"
The database has 2 related tables.
When editing a recordset I get a...
To Jerjim and Tschock
Here's the resolution for VB5 - Access 2000 problem
It is applicable to VB5 and VB6
Install Visual Studio Service Pack 4.
For ADO (or the ADO Data Control), use the "Microsoft.Jet.OLEDB.4.0" provider.
For DAO, go to Project menu, and choose References to use...
Yes! service pack 4 will work with VB5. As I mentioned earlier, Service pack 4 contains a value which enables VB5 to open an Access2000 database. I believe changes were
made to the service pack.
I have tried it with both VB5 and VB6, successfully.
Hellovb
I've connected to Access2000 database using data control object and when I try and add a new record using the recordset object I get the following error message:
Function or interface marked as restricted, or the function uses an automation type not supported in Visual Basic'.
can anyone assist?
I'm using VB5 and I'm unable to connect a data control to the database (Access/2000). Confronted with 'unrecognised database format'. Does anyone know why.
thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.