Board index » delphi » Access error "Object invalid or no longer set"

Access error "Object invalid or no longer set"

Hi,

I just converted my project from paradox to Access. When I open the
table on the screen it works fine. As soon as I try to change any info
on the screen I get an error: " General SQL Error. Object invalid or no
loger set. Table". What in the world does that mean?

I also have trouble with transaction control. Even though I explicitly
do StartTransaction, when I get to Commit, Delphi says that I " cannot
Rollback or Commit without issuing BeginTrans ". Is there something
special about Access that I should know?

Thanks in advance

Paul

 

Re:Access error "Object invalid or no longer set"


Quote
>I just converted my project from paradox to Access. When I open the
>table on the screen it works fine. As soon as I try to change any info
>on the screen I get an error: " General SQL Error. Object invalid or no
>loger set. Table". What in the world does that mean?

There is some information on this error on Microsoft.com but nothing I can
extrapolate from the information you have provided.

Quote
>I also have trouble with transaction control. Even though I explicitly
>do StartTransaction, when I get to Commit, Delphi says that I " cannot
>Rollback or Commit without issuing BeginTrans ". Is there something
>special about Access that I should know?

Try closing all the tables used in a transaction before starting the
transaction.

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

Other Threads