Are there any know issues with the BDE on multiprocessor machines?

Answer:

Yes. We have had reports that in very high traffic situations the BDE can cause an application to freeze or possibly give BDE Error $2A04. Your best solution if you are faced with this situation is probably to switch to a single processor machine or set the affinity mask of your process to run on just one processor. You may also want to consider a different form of connectivity such as ADO.