
HELP : Autocreate database using VB
You can use this code to create a new database
db = format(date,"mmm")& "-" & format(date, "yy") & ".mdb"
Set dbsmem = DBEngine.Workspaces(0).CreateDatabase(db, dbLangGeneral)
Quote:
> Hello,
> Can anyone give some suggestions for this.
> 1) Each month i have to create new database name as "DEC-00"
> 2) in the database itself have 3 huge table just for data
> 3) CAn i create stored procedure for the database that i create
> 4) Any article on this issues that i bring
> --
> --------------------------------------------------------------
> Any suggestions would be appreciated.
> Thank You
> Khai Mun, Ng