Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. hellovb

    Partial Search of Access Db from VB

    You could try using the LIKE operator combined with the following pattern matching character; %
  2. hellovb

    Problems Editing and Deleting

    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...
  3. hellovb

    Patch for VB5 to open an Access 2000 Mdb

    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...
  4. hellovb

    Help - Mission Critical - Using Vb5 to access an Access 2000 Database

    Yes, by installing Service Pack 4. Visit Microsoft Site.
  5. hellovb

    Patch for VB5 to open an Access 2000 Mdb

    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
  6. hellovb

    Patch for VB5 to open an Access 2000 Mdb

    Service Pack 4 now contains a value for the Connect property which allows DAO Data Control to open Access 2000 Databases.
  7. hellovb

    Patch for VB5 to open an Access 2000 Mdb

    Visit Microsoft site and search for 'Service Pack 4'. Hellovb
  8. hellovb

    problem with recordset (VB5 - Access2000)

    Cheers Doug, It appears that I do require a patch for VB5 for it to work with Access-2000. I now intend using VB6. hellovb
  9. hellovb

    problem with recordset (VB5 - Access2000)

    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?
  10. hellovb

    visual basic 5 - Access 2000 - data control

    bmj I changed database to older format as you suggested and it worked a treat. Thanks
  11. hellovb

    visual basic 5 - Access 2000 - data control

    I was trying to connect to the database using the data control object.
  12. hellovb

    visual basic 5 - Access 2000 - data control

    Unable to connect to Access 2000 from VB 5. Confronted with the following error message 'unrecognised database format'. Can anyone help. Thanks AB
  13. hellovb

    VB6.0, Access2000, ADO2.5, DataGrid help

    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

Part and Inventory Search

Back
Top