Recent content by JeffPalmer

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!

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...

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...

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...

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...

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...

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...

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...

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...

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

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...