Replies

Just a WAG!

Have you tried an external trigger, to fire the process from outside? If you application is going to import files that appear in a folder, you can hook into the OS to alert you to new or modified files. To ‘self’ trigger that, you could have your app write a little test ‘temp file’ that triggers the test import…..maybe pushing the process from ‘outside’ might help….

Just another WAG.

Just a WAG!

Have you tried an external trigger, to fire the process from outside? If you application is going to import files that appear in a folder, you can hook into the OS to alert you to new or modified files. To ‘self’ trigger that, you could have your app write a little test ‘temp file’ that triggers the test import…..maybe pushing the process from ‘outside’ might help….

Just another WAG.

I posted this to the AccessD List for you….

Okay, did a little testing on my own, with Access 97. Used the following code:

Dim i
Do Until i=-1
docmd.TransferText …….
i=i+1
Me.lblStatus.Caption=”Importing: ” & i
‘DoEvents
Loop

Now, as is, above, the code Kicked up an 2051 error when i=11593 (It had imported 46372 records). Stopping the code, compacting the database, repairing the database, nothing would let the code start up again (without immediately kicking up that error message….which said something along the lines of a dialog box was not clicked or something…..), until I closed Access, and opened it up again, then it started right back up.

Next time, it didn’t error, it just hung. It sat at a record level of ~120,000 for about ten minutes, then I just killed it. No error, but it was definitely failing.

Once I remove the quote before DoEvents, so that it would run, it seems to just fly, with no stopping. As I’m typing this, it’s imported the records 1.5 million times and still going.

Here’s my theory. Jet is multi-threaded. I’ve had a little experience with multi-threading VB projects. One thing I know with doing that, is you have to be EXTREMELY careful when accessing a database. In fact, it is almost mandatory to force only one thread to do db transactions. If two threads try db transactions ‘simultaneously’, all sorts of things will happen (from just losing the thread, all the way to corrupting the database….not kidding…). The reason is that Windows isn’t really paying attention to what a thread is doing when it gives time to the next one. So if two threads hit the db at the right time, it can REALLY get goofy.

I’m sure the developers had that in mind when creating the TransferText method, however, they also probably didn’t count on someone importing a file over and over and over, without a break. So what is probably happening, is that you are getting ‘thread lock’, where one or more of Jet’s threads are locked, and there is nothing you can do about it, until you close Access, which will release the Jet threads. Now, I think putting in a DoEvents simply let’s the VBA pause long enough to let the Jet threads finish what they need too, before being called again.

Hope this helps in someway.

Drew

Even though this is Access 97 (don’t have AXP), it is too much of coincidence to run into the same ‘mystery’ type of error. Different number, but obviously doesn’t have anything to do with what is really wrong.

Actually, it wasn’t uncommon to be climbing all over those things, cleaning, painting, etc. In a running engine room, it’s almost hard to tell if what you are climbing on is running, or if it’s just the room that is shaking! So it’s more for safety, to prevent anyone from thinking that ‘stationary’ shaft would be a good place to put their foot for a second….cause it would really be a good place to lose your foot in a second!

Actually, it wasn’t uncommon to be climbing all over those things, cleaning, painting, etc. In a running engine room, it’s almost hard to tell if what you are climbing on is running, or if it’s just the room that is shaking! So it’s more for safety, to prevent anyone from thinking that ‘stationary’ shaft would be a good place to put their foot for a second….cause it would really be a good place to lose your foot in a second!

So close. You got the why, but you changed the where.

Here it is:
The incandescent lights are over the generators, actually directly over the shafts between the turbine and the generator. The generators spin at 3600 RPM, to produce 480v (I think) AC at 60Hz. 60 Hz. is 60 times a second, or 3,600 times a minute. Since the generators supply the current for the ship, they are going to spin at the exact frequency of the AC power they produce. So, if you put only flourescent lights over the generator, you will get a stroboscopic effect, which would make the shaft appear to not be moving.

So close. You got the why, but you changed the where.

Here it is:
The incandescent lights are over the generators, actually directly over the shafts between the turbine and the generator. The generators spin at 3600 RPM, to produce 480v (I think) AC at 60Hz. 60 Hz. is 60 times a second, or 3,600 times a minute. Since the generators supply the current for the ship, they are going to spin at the exact frequency of the AC power they produce. So, if you put only flourescent lights over the generator, you will get a stroboscopic effect, which would make the shaft appear to not be moving.

I figure the bottom of the triangle is G, because it’s the missing letter in the sequence of the other ‘bottom’ letters. Don’t get the rest though.

I figure the bottom of the triangle is G, because it’s the missing letter in the sequence of the other ‘bottom’ letters. Don’t get the rest though.

Good question. By plant I mean engine room. A little more detail, hopefully this will help a little. On my ship (which was an aircraft carrier…not a sub, but this ‘puzzle’ would apply to all ships (more then likely non-nuke too)), we had 2 reactors. Each reactor was in a RAR (Reactor Auxillary Room), and each RAR had an associated MMR (Main Machinery Room). So there were four ‘rooms’ all together. The term ‘plant’ is really short for ‘power plant’, which is technically the combination of an RAR and an MMR. In reality, each RAR and MMR had 2 incandescent lightbulbs each. That may have confused the issue, but hopefully it will get everyone off of the radiation kick. This has nothing to do with radiation. (MMR’s didn’t have a reactor, just received Steam from the reactors in the RARs.)

Good question. By plant I mean engine room. A little more detail, hopefully this will help a little. On my ship (which was an aircraft carrier…not a sub, but this ‘puzzle’ would apply to all ships (more then likely non-nuke too)), we had 2 reactors. Each reactor was in a RAR (Reactor Auxillary Room), and each RAR had an associated MMR (Main Machinery Room). So there were four ‘rooms’ all together. The term ‘plant’ is really short for ‘power plant’, which is technically the combination of an RAR and an MMR. In reality, each RAR and MMR had 2 incandescent lightbulbs each. That may have confused the issue, but hopefully it will get everyone off of the radiation kick. This has nothing to do with radiation. (MMR’s didn’t have a reactor, just received Steam from the reactors in the RARs.)

I don’t post many puzzles….so I don’t know how long I should wait before posting the answer……

I don’t post many puzzles….so I don’t know how long I should wait before posting the answer……

ROTFLMAO! Very intriguing. Not to confuse this subject, but ironically, a flourescent lightbulb actually works on the Geiger Mueller Principle . That link shows a geiger-mueller chart, I think on the second page. There is a platue on that chart, where ‘geiger counters’ work. voltages within that platue produce a equal ratio of radioactive interaction, and hits on the outside element of a geiger mueller tube. Voltages lower then that, create lower ratios (because some ‘reactions’ recombine before hitting the outside element), and voltages higher then that create a cascading effect, where it ‘floods’ the tube, because one reaction creates a never ending chain reaction. That higher voltage section is what flourescent lights are based on.

But back to the original puzzle, the reason an Incandescent light is used, has absolutely nothing to do with the reactor itself, nor radiation.

ROTFLMAO! Very intriguing. Not to confuse this subject, but ironically, a flourescent lightbulb actually works on the Geiger Mueller Principle . That link shows a geiger-mueller chart, I think on the second page. There is a platue on that chart, where ‘geiger counters’ work. voltages within that platue produce a equal ratio of radioactive interaction, and hits on the outside element of a geiger mueller tube. Voltages lower then that, create lower ratios (because some ‘reactions’ recombine before hitting the outside element), and voltages higher then that create a cascading effect, where it ‘floods’ the tube, because one reaction creates a never ending chain reaction. That higher voltage section is what flourescent lights are based on.

But back to the original puzzle, the reason an Incandescent light is used, has absolutely nothing to do with the reactor itself, nor radiation.