[AccessD] TableDefs vs. QueryDefs

Thanks, Lambert,

So it would appear that TableDefs doesn't need quotation marks but
QueryDefs does. But I shall also modify the code to set a variable, like
yours.

Arthur

On Tue, Oct 23, 2012 at 5:10 PM, Heenan, Lambert <
Lambert.Heenan at chartisinsurance.com> wrote:

> Arthur,
>
> DAO Code?
>
> Set rst = CurrentDb.OpenRecordset("qryLCs" ,dbOpenDynaset)
>
> That works for tables of queries, though I would not use CurrentDb. Rather
> set a variable first
>
> Dim Db as DOA.Database
> Set Db = CurrentDb
> Set rst = Db.OpenRecordset("qryLCs" ,dbOpenDynaset)
>