Hi,
I have a project with a about 16 forms. On each form I access a recordset from an Access database via ado so the Form_load of each form contains
Set cn = New ADODB.Connection
cn.ConnectionString = "DSN=MyDatabase;"
cn.Open
Is there any way I can write this just once and establish a single connection to the database which will provide for all the recordsets required for the various forms while the program runs.
I did read somewhere that the connections can be written into a class and then made into a DLL which can be called each time you a connection is required.
Is this correct? Will it improve performance because at the moment it is painfully slow.
Any help much appreciated
AL
I have a project with a about 16 forms. On each form I access a recordset from an Access database via ado so the Form_load of each form contains
Set cn = New ADODB.Connection
cn.ConnectionString = "DSN=MyDatabase;"
cn.Open
Is there any way I can write this just once and establish a single connection to the database which will provide for all the recordsets required for the various forms while the program runs.
I did read somewhere that the connections can be written into a class and then made into a DLL which can be called each time you a connection is required.
Is this correct? Will it improve performance because at the moment it is painfully slow.
Any help much appreciated
AL