C
Charlie
How can I determine if a table exists programically? I
want to make sure a table exists before deleting it.
want to make sure a table exists before deleting it.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron Weiner
Why not just drop the table and trap for the error if it didn't exist?
Ron W
Ron W
N
Nikolai Novikov
Using the application object
dn catching the error
for ADP
Application.CurrentProject.AllForms.Item(<Form_Name>).Name
for MDB
Application.CurrentDB.AllForms.Item(<Form_Name>).Name
dn catching the error
for ADP
Application.CurrentProject.AllForms.Item(<Form_Name>).Name
for MDB
Application.CurrentDB.AllForms.Item(<Form_Name>).Name
J
Jim/Chris
I agree with the rest just delete the table and continue on
with any other processing. Here is some code example
Private sub.......
On Error Resume Next
DoCmd.DeleteObject acTable, "tablename1"
DoCmd.DeleteObject acTable, "tablename2"
' Insert your other processing needs
Update_Data_Exit:
Exit Function
Update_Data_Err:
MsgBox Error$
Resume Update_Data_Exit
ens sub
Jim
with any other processing. Here is some code example
Private sub.......
On Error Resume Next
DoCmd.DeleteObject acTable, "tablename1"
DoCmd.DeleteObject acTable, "tablename2"
' Insert your other processing needs
Update_Data_Exit:
Exit Function
Update_Data_Err:
MsgBox Error$
Resume Update_Data_Exit
ens sub
Jim