I built a database app for my brother's shop and really wish I hadn't. It's
a single table, Delphi 3.0 Standard BDE 4.0. We were getting "index out of
date" problems but found a freeware utility to fix this. Now (this is three
months down the track) we're getting "key violation. access denied"
problem. I am only (barely) a novice programmer with no experience other
than Delphi, which I tend to see as a sophisticated LEGO set on the
computer :-) and so have little understanding of what is happening or how
to fix it. To make matters worse, my brother's shop is in another state.
I'd be very gratefull for any help/advice. I know..... either buy some
books or use FileMaker....
Thanks. Paul. (email appreciated as I live in the country and the net costs
a fortune)

It sounds like you now have a corrupt table.  Does the utility you downloaded
repair tables?  If so run it on the problem table.   Are you using the table on
a network? If so do you have Local Share set to true?

Brian
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Hi Paul, it sounds almost as if your Index is not Maintained, do you know
how to make the index maintained from database desktop? If the maintained
box is checked just delete the index and re-create making sure you maintain
the index. Key Violation also indicates that there is a record being posted
for a Key Field which already exists, paradox tables require key fields
(please correct me anyone if I'm wrong) to be unique.

news:01bea2a8$f6500f80$f41257cb@paulwhym...