ADO question

[thinman]

Hi all

Does anybody know how to create a new database using ADO. I wanna create a whole new file (Data.mdb for example). I know how to create it using DAO by calling CreateDatabase function, but I don't know how to do this under ADO. I have one more question. I have two recordsets. First is a table and the second is a query (view). When I change a record in first recordset (table), the change isn't reflected to a second recordset (query) which is connected to a DataGrid control.

Thanks in advance!!

[Iouri]

Make sure you have a reference set to the ADOX object library then use the following code.

Dim objCatalog as ADOX.Catalog

Set objCatalog = New ADOX.Catalog
objCatalog.Create "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\mynewdb.mdb"




Iouri Boutchkine
iouri@hotsheet.com