Home  Fees/Services  Access Examples  Tutorials  Access Download  Articles  Search  Forums  Blockchain Tech  Contact  Privacy  Links
Application Object Examples
Close Current Database Code Example

Visual Basic Application Objects

 





Access Error
AddToFavorites
BuildCriteria
CloseCurrentDatabase
CodeDB
CompactRepair
ConvertAccessProject


Access CloseCurrentDatabase Method Example

CloseCurrentDatabase Method - You can use the CloseCurrentDatabase method to close the current database (either a Microsoft Access database (.mdb) or an Access project (.adp) from another application that has opened a database through Automation.



Our Access Programmers work with clients all over the world through the Internet. See why we are the: the best Access programming company.

We also have 100's of programming examples from simple to complex. You can jump to our Access tutorials here.


Here is a little example the opens another Access database and creates a form, then closed the database.  Can you envision the uses of this technique to write temporary table to another database (creating the database on the fly)?

Option Compare Database

Dim appAccess As Access.Application

Sub CreateForm()
Const strDBPath = "C:\My_DBs\"
Dim frm As Form
Dim strDB As String

      ' setup string to current database path.
strDB = strDBPath & "the_database.mdb"
      ' Create new instance of Microsoft Access.
Set appAccess = CreateObject("Access.Application")
      ' Open database in Microsoft Access window.
appAccess.OpenCurrentDatabase strDB
      ' Create a new form.
Set frm = appAccess.CreateForm
      ' Save the new form.
appAccess.DoCmd.Save , "New_Form"
      ' Close the newly opened database.
appAccess.CloseCurrentDatabase
      ' Cleanup
Set appAccess = Nothing

End Sub








A Blue Claw Database Design Article:

Learn How To Select A Consultant
 





Blue Claw Database Design Downloadable Tutorial:
Programming MS Access Security Alternative  





A Blue Claw Software Design Template:

Meal Delivery Service Solution
 



Contact Information

Copyright 2000-2018 Blue Claw Database Design