I have a BE reporting.mdb, its tables are linked into the FE

Because of the constant deleting/inserting of data, there is bloat
to solve this, the FE autoexec copies in a master copy of the
reporting.MDB

this worked fine with access97, but with the access2007-runtime when
deleting data
currentdb.execute "DELETE * FROM tblFoo"

I get an error
"Record is deleted. ,DAO.Database ,3167"

there are no memo fields in tblFoo
the last office updates / patches have been applied

is this an access2007 issue ?
what could I try to solve the problem ?

Roger <lesperancer (AT) natpro (DOT) com> wrote in
news:ecffb562-1763-465b-8020-6d7fc46921bd (AT) n3g2000yqb (DOT) googlegroups.com
:

What about:

CurrentDB.execute "DELETE tblFoo.* FROM tblFoo"

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/