I have XP Professional and my database is 2000 format. Anytime I have in my
code the DoCmd. cmd. or Me. and I debug I get hung up there.
I have Microsoft ActiveX Data Objects 2.1 Library referenced and my dim
statements are:
Dim blnQueryExists As Boolean
Dim cat As New ADOX.Catalog
Dim cmd As New ADODB.Command
Dim qry As ADOX.View

I know this isn't much for you to go by, but does anything stick out that I
should be doing or not doing?

"Sheryl" <(E-Mail Removed)> wrote in message
news:A1884657-FC89-4419-8032-(E-Mail Removed)
> I have XP Professional and my database is 2000 format. Anytime I
> have in my code the DoCmd. cmd. or Me. and I debug I get hung up
> there.
> I have Microsoft ActiveX Data Objects 2.1 Library referenced and my
> dim statements are:
> Dim blnQueryExists As Boolean
> Dim cat As New ADOX.Catalog
> Dim cmd As New ADODB.Command
> Dim qry As ADOX.View
>
> I know this isn't much for you to go by, but does anything stick out
> that I should be doing or not doing?

You're right, it isn't much to go on. You don't mention that you have a
reference to "Microsoft ADO Ext. 2.x For DDL and Security", which you
would need in order to define an ADOX.Catalog or View object, or any
other ADOX objects.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

=?Utf-8?B?U2hlcnls?= <(E-Mail Removed)> wrote in
news:A1884657-FC89-4419-8032-(E-Mail Removed):

> I know this isn't much for you to go by, but does anything stick out
> that I should be doing or not doing?
>
>

No it isn't. What is the code that causes the error and what error message?

Tim F