Question:
Why am I getting a paradox lock or table busy error
when I'm accessing data on a SQL server in my application (not paradox)?
Answer:
You are probably using Cached Updates in you project.
When the BDE caches your data it is stored inside a
paradox table. This happens when an application is
being run off a server and there is more then one user
executing the application. It is easily fixed by
setting the paradox NetFile Directory and Private
Directory to a temp directory such as " C:\ " (see the
documentation for TSession for PrivateDir and NetFileDir
properties)