Visual Basic

[arudrakumar]

1) How to create a new database on a remote server (eg. To create a new Access
database VB calls CreateDatabase()). Likewise we require a code to create a
new ODBC like SQL or Oracle Database using ADOs or RDOs ?
2) How to initialize this database through Package and Deployment wizard ?

[Raptors Fan]

I don't know if this is can help you but you could create an Access database as follows:


Dim appAccess as Access.Application

private Sub Command1_Click()
set appAccess = new Access.Application

appAccess.NewCurrentDatabase "C:\WINDOWS\Desktop\MyDB.mdb"

set appAccess = nothing
End Sub




You will need to add Reference to "Microsoft Access 9.0 Object Library" (ACCESS 2000)

RF