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
Microsoft Access is a fully capable database and it's primary limitations is the number of concurrent users it will support. Generally, we recommend a limit of 10 to 15 users.
Did you know you don't need to move to SQL/Server to run and manage your Access database on the net. There are many alternative solutions. Among them are Amazon's AWS cloud services and various hosting services in nearly every state.
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
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.
' Create a new form.
Set frm = appAccess.CreateForm
' Save the new form.
appAccess.DoCmd.Save , "New_Form"
' Close the newly opened database.
Set appAccess = Nothing