Database Heap Size and Creating Instance

[klove1209]

Good afternoon,

I was asked to create an instance of my Database on a local drive and I am not sure how to accomplish that task?

I was also told to research on how to increase the heap size.

Can someone please provide me with direction?

Thanks,

[ADezii]

Good afternoon,

I was asked to create an instance of my Database on a local drive and I am not sure how to accomplish that task?

I was also told to research on how to increase the heap size.

Can someone please provide me with direction?

Thanks,

1. As far as I am aware of, Heap Size is not a Configurable Parameter in Microsoft Access.
2. The following code will create an Instance of an External Access Database and treat it as the Current Database within an Access Window via Automation. It will then open a Table and display its Records. When an attempt is made to open another Instance of the Current Database via automation, Access generates a Run Time Error. I apologize but I really do not have the time to research this further but it does provide you with at least a starting point.

'In the Declarations Section of a Standard Module
Public objAccess As Access.Application

'Create a New Instance of Microsoft Access
Set objAccess = CreateObject("Access.Application")
 
objAccess.Visible = True
 
'Create an Instance of an External Access Database
objAccess.OpenCurrentDatabase "C:\<your directory>\<your database>.mdb"
 
'Open the Table
objAccess.DoCmd.OpenTable "tblSite"

'Close the Database Instance
objAccess.CloseCurrentDatabase