ADP/SQL 2000 update rollback

J

Jim

I'm using an Access 2002 ADP and SQL Server 2000. I have
a form that is bound to the table (it will only ever be
accessed by one or two users). I added an UNDO button
using a wizard. Additions, updates, deletes and record
navigation work fine. However, when I click the undo
button after a table entry has been saved (doesn't seem to
matter whether I've moved focus off the record or not), I
get a message "Microsoft Access has encountered a problem
and needs to close. We are sorry for the
inconvenience". The rollback or the record has actually
occurred correctly.

When I import the form into an MDB and link to the table,
the UNDO performs as expected.

Any help would be appreciated.

Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top