Search results

Excellent idea. By Counter, what are you suggesting? I would not want control to exit back to the calling code, if possible. I am not sure if that is happening, but if it is, that is why I ask. Not ask to my last post stating that my repairs last night didn't seem to do anything, I may...

As far as I can tell, properly closing out the IO resourced and equating them to nothing also did nothing. It still slows down. I am looking at the application using 65,400K right now in the Windows Task manager. In my serial communications routines, there is one receive while/wend loop that...

Hmmm, yea, Labview would have been the way to go, I guess. Getting hardware, such as Agilent test equipment, is much easier than getting software, even if the hardware is much, much more expensive. Why Access?? ...cause it is what I was familiar with with. I have VB6, but don't know how to...

Ah, okay, thank you. I did not know that. I remember when we first got our PCs, Runtime was on them. Then they were re-imaged with the full version of Access. I just wanted to try it. I may have un-covered something else that may be causing this..... I should know in the next couple of...

Re: Slow Access High Dave, if you are still around, did you ever find a solution for this slow down? Which XP service were you shutting down/ I assume with the task manager?

This slow-sown is still an issue even using an MDE version of the program. I am wondering about Access 2000 Runtime but can't seem to find that in Microsoft's site anymore. After the first three pages of test routines, the program starts operating sloowwww. Exit Access, restart the program...

Yes, thank you. Some time back I went through a number of report modules and had to go "oops" <g>. Now when ever I open a record set and database, before any other code is written, then next lines are: rs.close set rs=nothing db.close set db=nothing.

Confort zone, reporting, knowing it well enough. I have VB6 and have done some cool instrument control utilities, but don't know it well enough to open data tables, change the structure and store the data. I am not familiar with its ability to do reporting. I also get fustrated with its...

Hello there. When I reported the memory, it is from the Processes Tab of the task manager. So 40,000K is 40 megs. Not much in a machine with 1 gig ram, but the performance issue (in the other thread is/was horrible). It is just interesting that when a form is opened, about 10 megs of ram is...

Is there anything else that should be done when a form is closed? I ask this because I have observed with the Task Manager, Access 2000 taking 20,000K memory with my main form open. From there I link to another form, keeping main form open. With that second form open, Access is sucking up...

Re: Access Code Slows way down Second time it is run Okay Doc Man, here is another clue... Looking at memory useage, when my first form loads, it is 20,000K. The I load an adjust form, it goes up to 27,000K. When I exit and close that form, it only drops back down to 25,000K. I would bet...

Printed out the code of the module on 8.5x11 paper landscape mode. Took 150 pages. I am about 3/4's of the way through the code. So far I have seen no mistakes. however, I see that where I passed the single dimensioned variable Results() to a local function. Results was dimensioned at the very...

Finally got back to using the program. That routine is slowing down to a crawl again. Here is the memory usage. I need to investigate some more line by line.

Is this the kind of screen shot you wanted to see? It is not when the massive TestGen form and routines are running (I can not do that here at home), however a CPU intense test is running. I found numerous poorly dimensioned String Arrays and have converted them all to fix length string...

Going through code now... I found one plase so far in a different procedure that runs 3 or 4 forms before that one I had in question. It was: dBerror(10, 16) As String I changed it to: dBerror(10, 16) As String * 8 <- that is probably one byte more than needed, but I trim it during the save...

Thanks for the detailed replu. Unfortunitely, I am packing up this morning for a quick service run to a customer, and will re-read your reply when I get a chance. I did capture the Task Manager screen shots while the program was running. I do not understand a lot of it but have uploaded it...

I monitor the Performance TAB of the task manager. Available memory and the other readings were not drastically effected. In my code, I read a "signal height" from our instrument, via the serial port. In high gain situations, I have that routine interpret the signal from the noise. Now, I...

One function slowing down? I don't think so, anything I do with the program after that data collection page is sloowwwww; anything. The whole system slows to a creep until I exit the database and restart it. I have been going through code, making sure that I closed all recordsets and dbs...

Access Code Slows way down Second time it is run Hay there, I have one form with a rather large amunt of code behind it collecting data from an electronic instrument (via serial commands to that instrument and via GPIB interface to some test equipment). Anyway... The first time I run this...

I put it in a support module that has a while bunch of other pulic functions and subs.