another 4 am day….
Ok, 4:20am wake up call this morning. It was the usual database error. I ran the repair that Access suggested using.
That has worked well in the past here, but it doesn’t *solve* the problem. Just starts everything, which is what we want.
I looked at the file size. 250 kB or so. I say screw it, and I run the “compact database” command. File size is now down to 180 kB.
Only way to know if it works is tomorrow morning!
edit:
The day ended for me at 6:50 when I walked out the door. Stupid Biesse router was acting up. The Italians are going to remote into it tonight, and hopefully have solutions for us in the morning. Which means an early day tomorrow as well. Maybe I should just go back into the operations/production side of things again. A bit more pay, probably similar hours to what I am actually doing now, rather than the supposed to ( 50 to 6o vs 40 to 50) We shall see
August 29th, 2005 at 6:21 pm
Ah, the trials and tribulations of MS Access. Having built quite a few of those, I can say that while as a basic database it is pretty easy to set up, anything advanced leads to limitations and annoyances. Out of curiosity, what’s the issue?
August 29th, 2005 at 8:11 pm
The Access database “ToolTable” blew up. Gave a crazy message in Italian (oh yes, the machine is all in Italian). Usually, I just click on repair when the message comes up, or replace the database with a back up.
But this time, hopefully, compacting it will be more advantages
If it happens again, I’ll try to write down the error for you.
August 29th, 2005 at 8:59 pm
So wait a sec, you’re telling me this router machine runs off of an Access database? What are those Italians smoking?
On the bright side, compacting and repairing the database can be helpful in eliminating issues. Then again…
August 30th, 2005 at 5:02 am
Nope. Sorry for the misunderstanding….
Yesterday, the Gabbianni double end tennenor was the early morning problem. It’s a machine that has 4 rotating tools, that performs a squaring operation while applying a profile to the edges of the part. Parts are fed in as continuous line, the lengthwise sides get profiled first, then the parts are moved 90 degrees through a second machine (same controller computer system though), for the width wise sides.
That’s run off of Access…. The Italian’s crazy thinking is that Access allows you to keep each part number separate, and then have a massive data tracking system behind it. Start time, stop time, length of break time, maintenance time, cleaning time, etc. Great idea. When it works. It just doesn’t work that well. The only info on the web I can find on Gabbiani is just their distribution system. And none of those machines listed there are what we have.
Now the routers, those run of an Osai PLC controller. The models being made today have a windows controller, but that’s not an easy upgrade to some older machines.
August 30th, 2005 at 5:29 am
oh yes, no early morning wake up call today…. I actually slept in 15 minutes too late, so no breakfast for me!