B
bwion
I have a quick question about some of the code that I have seen for
establishing a persistent connection to the backend of an access database to
increase performance. Here are the links that I am specifically referirng to:
http://www.granite.ab.ca/access/performanceldblocking.htm
http://support.microsoft.com/kb/303528/EN-US/#15
If I do set it up this way (by declaring a static DAO database object with
the backend) do I have to declare DAO database objects in other portions of
the program. For example, if I have a command button that uses DAO to add
data to a table to I still have to include the:
Dim dbs As DAO.database
Set dbs = CurrentDb()
~~~~Code~~~~~
Set dbs = Nothing
Isn't that reopening a connection with the backend or is that establishing a
connect with the front end? I just want to know if by adding this persistent
connection code and then using the above code in my procedures if I am being
counterproductive (establishing a connection twice and also defeating the
purpose of the persistent connection). Thanks for any tips.
~Ben Wion
establishing a persistent connection to the backend of an access database to
increase performance. Here are the links that I am specifically referirng to:
http://www.granite.ab.ca/access/performanceldblocking.htm
http://support.microsoft.com/kb/303528/EN-US/#15
If I do set it up this way (by declaring a static DAO database object with
the backend) do I have to declare DAO database objects in other portions of
the program. For example, if I have a command button that uses DAO to add
data to a table to I still have to include the:
Dim dbs As DAO.database
Set dbs = CurrentDb()
~~~~Code~~~~~
Set dbs = Nothing
Isn't that reopening a connection with the backend or is that establishing a
connect with the front end? I just want to know if by adding this persistent
connection code and then using the above code in my procedures if I am being
counterproductive (establishing a connection twice and also defeating the
purpose of the persistent connection). Thanks for any tips.
~Ben Wion