I have create a database in ms access 2007 but i don't have to connect this database to vb6.0

please help me.........

Recommended Answers

All 3 Replies

I have create a database in ms access 2007 but i don't have to connect this database to vb6.0

please help me.........

I assume you are having trouble connecting to the database. There are multiple methods.

  1. RTFM (friendly manual of course)
  2. there are a number of DB-linking controls like the DBgrid, the DBcombo, ... you would enable them under Project - Components. Look for something like "Microsoft Data Bound ... Control"
  3. To just use Data from the DB and process that somewhere in your code, just use the database objects of VB:
    myDB = new ADODB.Connection 
    myDB.Provider = "Microsoft.Jet.OLEDB.4.0" 
    myDB.Open DB_File

    This would be the ADO variant

  4. Use the "classic" DB functions of VB.
    DIM myDB as Database 
    SET myDB = DBEngine.Workspaces(0).OpenDatabase(dbFile, False, False)

If you don't have to connect to the database to vb 6.0 then what is the problem ? Why have you posted here ?

Use the data form wiard with all possible combinations of form types with each of the code/class/control options.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.