Error Handling for Altering Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On a MS Access form, I have a button to invoke the ALTER TABLE statement in
code to update a target table. Is there a way to capture errors return from
the ALTER TABLE statement? If so, how. If not, any other options?
 
Charles said:
On a MS Access form, I have a button to invoke the ALTER TABLE statement in
code to update a target table. Is there a way to capture errors return from
the ALTER TABLE statement? If so, how. If not, any other options?
Click to expand...


If you use the Execute method instead of RunSQL, then, Yes,
you can. Check Help for details and post back with more
information if you need further assistance.
 
Thanks for your information.

Marshall Barton said:
If you use the Execute method instead of RunSQL, then, Yes,
you can. Check Help for details and post back with more
information if you need further assistance.
Click to expand...
 
Back
Top