how do I reset sql code in a table if rollback's not in Access?

G

GMU Girl

I updated a record using SQL code and changed the attribute in one of the
fields. I now want to reset it to the original value. How do I do that
since reset or rollback don't exist in Access?
 
D

david epsom dot com dot au

application.dbengine(0).BeginTrans

....

application.dbengine(0).Rollback

What are you trying to do?

(david)
 

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

Similar Threads

VBA - (re-) Set a Table Style 2
How can I reset my normal template it its default. 1
How do I clear a form? 0
Autonumber field in Excel that behaves the same as Access 0
To reconstruct a data table 1
Can I save a sql statement generated by a search form? 1
Adding data to MS Access from csv file 0
sql string as field data; ado? 1

Top