Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kcmccc

    ADP Data Refresh

    I have an ADP w/ SQL 2000. Multiple users use the same form, a list-view of records. Because the ADP does not refresh data on a regular interval as an MDB does, if a user updates data in one record, the other users do not see that new data unless they manually click refresh. What I need is a way...
  2. kcmccc

    SQL Time Out on ADP

    I do have some rather large updates. I am using optimistic locking. I have not tried changing the time out option through Access, but I had done so on the server with no results.
  3. kcmccc

    SQL Time Out on ADP

    I do use alot of ADO recordsets, but I close/set them all to nothing when done with them. Since this is an ADP, all of the stored procedures and views are in SQL. There are alot of them as the database is quite large. There is no one sequence that triggers the error, a simple "Time Out Expired"...
  4. kcmccc

    SQL Time Out on ADP

    I have an ADP/ADE file linked to SQL 2000 with about 10 users. As users log in and logout SQL does not release the users memory, and so the memory usage continues to grow until eventually SQL begins to give Time Out errors to the database users. Any idea why this might be happening or what I can...

Part and Inventory Search

Back
Top