code_junkie

create databases in ms-access, then delete a particular database. using any vb query or vb code

Nov 12th, 2011
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. Set fso = CreateObject("scripting.filesystemobject")
  2. fso.CopyFile "c:db.mdb", "c:db_copy1.mdb", True
  3. fso.CopyFile "c:db.mdb", "c:db_copy2.mdb", True
  4. fso.CopyFile "c:db.mdb", "c:db_copy3.mdb", True
  5. fso.DeleteFile "c:db.mdb"
  6.  
  7. createDatabase "myNewMDB.mdb", dbLangGeneral
  8.  
  9. kill "myNewMDB.mdb"
  10.  
  11. public Function createDeleteDatabase(howManyDatabases as integer) as boolean
  12.  
  13. ''output is by default False
  14. createDeleteDatabase = False
  15.  
  16. on error goto createDeleteDatabase_Error
  17.  
  18. Dim i as integer
  19. For i = 1 to howManyDatabases
  20. createDatabase "myMDBNumber_" & str(i,0) & ".mdb", dbLangGeneral
  21. Next i
  22. For i = 1 to howManyDatabases
  23. kill "myMDBNumber_" & str(i,0) & ".mdb"
  24. Next i
  25.  
  26. ''if no errors in the fonction, set the output to True
  27. createDeleteDatabase = True
  28.  
  29. Exit function
  30. createDeleteDatabase_Error:
  31. '' your error treatment
  32. End function
Add Comment
Please, Sign In to add comment