Re: Connection object question

Stephen Howe wrote: 
Is there any way I can have a connection to an SQL Server database in
exclusive mode ? If there was a way would this speed up changes to
tables in that database ? Is there any connection mode which would be
effective to speed up any changes when I know that no other connection
will be accessing a particular database when my program does ?



You can change the properties of the database via Enterprise Manager so that
only one user has access to the database.

Stephen Howe



I need to do this programatically with ADO for my connection's database if it speeds up processing of the tables in the database.
.

Relevant Pages

  • Re: mainframe career advice
    ... >> Using standard software a single PC can typeset about thousend pages ... A PC database can easily deliver 20 thousend rows per ... speeds were changing slowly in recent two years I guess that z9-109 ...
    (comp.lang.cobol)
  • Re: How to determine optimal MTU for VPN users
    ... A file-server database like MS Access shouldn't be used over a VPN. ... application performance can easily be acceptable over the lower link speeds. ... my house has 256 upload so my vpn connection is more like a 200kb. ...
    (microsoft.public.windows.server.sbs)
  • Re: Connection object question
    ... Stephen Howe wrote: if it speeds up processing of the tables in the database. ... speeding access to SQL Server database tables when making changes? ...
    (microsoft.public.data.ado)
  • Re: Embedded Database Recommendations?
    ... performance (specifically SELECT speeds and memory footprint)? ... Well the SELECT speed and memory footprint of mySQL are both superb. ... 1GHz and 1GB RAM. ... Number of concurrent users (access to database) ...
    (comp.arch.embedded)
  • Re: Tabledef.append - SLLLOOOW
    ... Instead of using CurrentDb 30 times, create a database variable ... connection open and so speeds the entire operation: ... Dim dbBE As DAO.Database ...
    (microsoft.public.access.formscoding)