Creating a database at runtime and saving the database

[Leeper77]

I have a question ok i have a database i want to be created at run time how do i go about doing that in the program its a personal inventory so it has to be saved evertime things are added and updated so if any of you could help me that would be great

[Clunietp]

DAO or ADO?

[Leeper77]

i use the data control in the other databases i dont know much about the differant types. But i do know what i want it to do. the database that will be used could be viewed in its own form with a datacontrol hopefully. I hope im not confusing you but im not the best at vb

[Clunietp]

You're probably using DAO. Here is an example that creates a database, a table, and two fields.

    Dim db As Database
    Dim tbl As TableDef
        
        
    'create the database
    Set db = DBEngine.CreateDatabase("C:\test.mdb", dbLangGeneral)
    
    
    'create table object
    Set tbl = New TableDef
    tbl.Name = "New Table"
     
    
    'add fields to table
    tbl.Fields.Append tbl.CreateField("TestField", dbText, 100)
    tbl.Fields.Append tbl.CreateField("AnotherField", dbText, 50)
    
    
    'add the table to the database
    db.TableDefs.Append tbl
    
    
    'close database
    db.Close
    Set db = Nothing

HTH

Tom

[Leeper77]

ok thats kinda how i did it but i have one more question.

I would like to copy one row from one database and control and form to another database and control and form any idea on how i can do this?

thanks