[AccessD] A2K: OpenRecordset doesn't

Thanks to all who replied.

I went to the (not) Help and am now using some
plagiarised code directly for ADO
It seems to work

Thanks Susan and Andy



----- Original Message -----
From: "Susan Harkins" <harkins at iglou.com>
To: <accessd at databaseadvisors.com>
Sent: Sunday, April 13, 2003 12:51 AM
Subject: Re: [AccessD] A2K: OpenRecordset doesn't


>
> Well, you don't need the ; at the end of the SQL
statement, but don't know
> that it's your problem.
>
> Susan H.
>
>
> > Can anyone shed some light on why my code
fails on
> > the line...
> >  Set rst = dbs.OpenRecordset("SELECT * FROM
> > tblMyTable;", dbOpenDynaset)
> > and I get the error "Run time error 13 'Type
> > Mismatch"
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
>
http://databaseadvisors.com/mailman/listinfo/acces
sd
> Website: http://www.databaseadvisors.com