Jack Jenkins

After I typed that, I realized that not many people who should, do take testing into consideration. Again, thank you for your concern.

Also, I feel like an idiot, I should have known what you were talking about (regarding the Admin/Exclusive user). It just isn't referenced the same here, so I thought there may have been something missing.

That aside, I didn't have to re-index or delete .CDX files within MOM when I used the other method I posted last. What do you think? Is that the best way to accomplish what I am doing?

More information - Hopefully this helps someone.

When doing a mass price update, there needs to be a table created with the price, quantity, and part number laid out in a vertical format:

SD12 ....... .8500 ....... 5
SD12 ....... .8000 ...... 10
SD12 ....... .7500 ....... 15 , and so on

I just created this in excel.

Then using Access, import both the PRICE table from MOM and the new price worksheet from Excel. Make an update query, then link the two tables via part number and update the quantity and price on the PRICE table.

Then to the problem I was having - someone tell me if there is a better way to do this - I then export to a .CSV with no text qualifiers, and open dbuwin. Open PRICE table, zap, and append from your .CSV.

Have tested both mass price change AND removing mass bad emails - hope this helps.

Of course I am working in a test environment, that goes without saying (one should hope). Thank you though for the concern, I completely understand your viewpoint.

I did completely re-index MOM, to no avail. However, I did not attempt to delete .CDX files. Can you give me more details on that procedure?

Also, as far as "exclusive" user goes, do you mean the only user logged on? or is there an "exclusive" (or power) user account?