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...
 
You must log in or register to reply here.

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

ALTER TABLE ADD 7
Access Access VBA question 0
VBA - Code stops running correctly 2
Change Required Field Property in Table 4
Calling Error Handling in VBA 1
Alter Back-End Table from Front-End 5
Alter table command in SQL Server 2
ALTER COLUMN syntax 2

Back
Top