By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,940 Members | 611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,940 IT Pros & Developers. It's quick & easy.

Suppress "Object Already Exists" Message

P: n/a
Hello,

How does one suppress the "Object already exists" message when the
following statement is executed in ADO?

cat.Views.Append "Some_Query", cmd

Thanks in advance.

Uttam
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
u0***@hotmail.com (Uttam) wrote in message news:<77*************************@posting.google.c om>...
Hello,

How does one suppress the "Object already exists" message when the
following statement is executed in ADO?

cat.Views.Append "Some_Query", cmd

Thanks in advance.

Uttam

Delete the View before appending and suppress the "object doesn't
exist" error, then append. If you put something like On Error Resume
Next or whatever in the code, the errors should just get ignored. If
it returns a numeric error, you can just trap for that error and
continue.

if Err.Number= lngSomeNumber Then
Err.Clear
Resume Next
End if

(Yeah, I know, I prolly butchered the syntax.)
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.