On Tue, 5 Jun 2007 17:11:00 -0700, Ed C <Ed
C@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I am using SQL server 2005 with multiple client databases with the identical
structure. Is it possible to disconnect from one database and connect to
another within the same ACCESS 2007 project? In Access 2007 connecting to
the database through an ODBC connection (with linked tables) is slower. I
would like to have the direct access for speed purposes. Any help on this
qould be greatly appreciated.
Re: why dataset in ado.net is disconnected ... need to be able to support thousands of concurrent users on a server... application - all interacting with the database in a real-time mode. ... Either maintain an open connection all the time. ... possible and to encourage you to disconnect as soon as possible - for the ... (microsoft.public.dotnet.framework.adonet)
Re: DBI and modules ... On Friday 17 October 2003 08:22 am, Simon Taylor wrote: ... creates a database handle and passes it back to the calling ... > disconnect().... > Script to create the connection poe_ctrl.pl ... (perl.dbi.users)
Re: To connect to a database. ... to connect and disconnect on every single database request,... are loading a listbox manually from a database and on the same page, ... I would certainly close the connection after each query, but you could have a Populatemethod in your code which calls one stored procedure that returns multiple resultsets for all the information required for the page, close the connection, and then populate all the controls from the data. ... (microsoft.public.dotnet.framework.aspnet)
Re: automate Access project connection to MSDE database ... When you create a new access project, there are connection settings that need ... is made to the MSDE database, Access will then display all the tables in the ... (microsoft.public.sqlserver.clients)
