vbscript-create-a-blank-database

VBScript - Create A Blank Database

This script file allows you to create a blank MS Access database.

VBScript

  • 326
  • 186
  • 2
  • 0
Add to collection
© VBAmacros.net2020

1 Open your favorite text editor. In our case we are going to use Notepad++

2 Copy the VBScript code from below.

3 Paste the code in the newly created file.


4 Save the file with a ".vbs" extension.


5 Run the script file by double-clicking on it or via the CMD console.


6 That's it!


Advertisement

Code
' This script creates a blank MS Access database.
Sub createBlankAccessDatabase()
	' Set variables
	Dim appAccess
	' Create new access application object
	Set appAccess = Wscript.CreateObject("Access.Application")
	' Add a new database
	appAccess.NewCurrentDatabase("F:\VBAmacros\VBScript\dbTest.accdb")
	' Release the access application object
	Set appAccess = Nothing
End Sub
' Run the procedure
Call createBlankAccessDatabase()
Advertisement


Comments
Sort by:
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
VBAmacros.net VBAmacros.net
Code was successfully copied!
VBAmacros.net VBAmacros.net
Please sign in!
VBAmacros.net VBAmacros.net
You've already voted!