Yes. Once was enough due to the difficulty finding the bug. Kapersky blocks valid application with access database after update on 04/09/2014[^]

For an order entry software which creates the files for automated machines in the factory. Customer: Can you please tell me where I need to go to change the size of the smallest piece that is able to be cut? Me: What is the size of the part? Customer: Well, the part is 3.250" high and the length is 6.500" less than the base height. Me: You realize that makes the length a negative number? Customer: Yes, but we must have the part. Me: The part has a negative length! Customer: I know! Now tell me which setting to change to allow small parts!!! Me: Okay, but The Department of Home Land Security warned us that it could break space and time. Go to the global settings and in the empty field marked spare, type NL=OK. Customer: That worked, it even allowed more parts to fit in that sheet of material. Thanks. A few hours later, the machine begins cutting parts, a large bang is heard. An enormous rift develops where the machine once sat; everything is pulled into the rift. All life ended Friday 19 October 2012.

That worked perfectly. Thank you

No value given for one or more required parameters.

I am new to mdb data bases and trying to copy data from a column in one table to a column in another table. Recently I wrote a short program to correct the data in one table of several mdb files. Below is the code I was using which works fine.

        'removes unwanted characters from Optional Info23 
        Dim OpInfo23\_upd As New OleDbCommand
        OpInfo23\_upd.CommandText = \_
            "UPDATE OP\_INFO SET OPINFO23 = mid(OPINFO23,'2','8') & mid(OPINFO23,'11','2') WHERE OPINFO23 > ''"
        OpInfo23\_upd.Connection = conn
        OpInfo23\_upd.ExecuteNonQuery()
        'sets flag character in Optional Info25 
        Dim OpInfo25\_upd As New OleDbCommand
        OpInfo25\_upd.CommandText = \_
            "UPDATE OP\_INFO SET OPINFO25 = mid(OPINFO23,'1','1')"
        OpInfo25\_upd.Connection = conn
        OpInfo25\_upd.ExecuteNonQuery()

Now I am attempting to add the code to copy the data from the NAME column in the required information table (REQ_INFO) to the OPINFO29 column in the optional information table (OP_INFO). I tried the code below, but it generates an exception. Is it possible to update the table directly from another table?

        Dim OpInfo29\_upd As New OleDbCommand
        OpInfo29\_upd.CommandText = \_
            "UPDATE OP\_INFO SET OPINFO29 = REQ\_INFO.NAME WHERE OP\_INDEX = REQ\_INFO.REQ\_INDEX"
        OpInfo29\_upd.Connection = conn
        OpInfo29\_upd.ExecuteNonQuery()