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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JeffPalmer

  1. JeffPalmer

    Out of Memory searching an Access table

    I want to thank everyone for your invaluable help! Once I understood how to pass parameters to the SQL statement, it was easy to change the code references to TADOQuery from TADOTable (Roo, that link was definitely helpful! [2thumbsup] ). THANK YOU THANK YOU THANK YOU ALL!
  2. JeffPalmer

    Out of Memory searching an Access table

    I'm missing something with the ADOQuery. I keep getting a parameter missing error when I activate the query. ADOQuery1.sql.Clear; ADOQuery1.sql.Add('Select * from Procedures where ORD_ID="6904409"'); ADOQuery1.active := true; I do not get an error if I leave off the where clause. Should...
  3. JeffPalmer

    Out of Memory searching an Access table

    After stepping through the code, the issue is definitely the locate function. After some additional research, I found that using seek instead of locate may solve the issue, but when I try that, I get an error that it is unsupported. As mentioned, the column I'm searching through is a key index...
  4. JeffPalmer

    Out of Memory searching an Access table

    I created a .UDL file for the connection information to be read from. The connection string in the .UDL file is: DBQ=C:\Cedars\Procedure Tracking.mdb;DefaultDir=C:\Cedars;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;FILEDSN=D:\Program Files\Common Files\ODBC\Data...
  5. JeffPalmer

    Out of Memory searching an Access table

    They need to have historical data that goes back to 2004 to track about 2500 clients. I can probably convince them to go back to just 2006 (what currently is in the database) which is about 1.3 million records. The DB itself isn't that big, less than 300meg. What the program does is take a...
  6. JeffPalmer

    Out of Memory searching an Access table

    Due to multiple constraints, implementing any other solution is not possible. As I mentioned, this was a stop-gap to get them off of Excel in the interim of getting their client/server based system in about 18 months. Is there nothing I can do to improve performance with what I have now? I...
  7. JeffPalmer

    Out of Memory searching an Access table

    I guess I was wrong about performance. Changing the CursorLocation to clUseServer did solve the memory problem. Unfortunately, now it only processes about 3 records a minute (before the database grew too big, it was running around 500 records a minute)! The rest of the code runs at an...
  8. JeffPalmer

    Out of Memory searching an Access table

    I just have it connecting to the mdb file via TDataSource and TADOTable, and as you can see from the code, it just calls locate to find the ORD_ID number. If this is causing Delphi to cache the entire table or database for the search, it explains why I run out of memory. The TADOTable cursor...
  9. JeffPalmer

    Out of Memory searching an Access table

    I have a Delphi 6 application that connects to a Microsoft Access 2002/2003 database and adds about 1100 rows a day. The program was running fine until there were around 975k rows in the Access table. I now get an error that the Microsoft Access driver is unknown. While running the app inside...
  10. JeffPalmer

    GUI unresponsive on high CPU utilization

    That did it! Wasn't even a noticeable performance hit! I completely forgot about that command. Thank you so much!
  11. JeffPalmer

    GUI unresponsive on high CPU utilization

    I wrote a Delphi 6 app that processes a text file and then populates an Access database. The program pegs the CPU, but otherwise runs fine (even though task manager shows it not responding). It does take some time for the program to run, so I added an abort button and status gauge. The gauge...
See more

Part and Inventory Search

Back
Top