[AccessD] OpenRecordSet question

I discovered this when I found that

Set tdf = Currentdb.Tabledefs("myTableDef")

 doesn't work, but

dim myDB as Database
set tdf = myDB.Tabledefs("myTableDef")

does work

Doug Steele

On Fri, Aug 7, 2009 at 3:43 PM, Max Wanadoo <max.wanadoo at gmail.com> wrote:

> IMO one should always dim the DB object.
>
> I believe that the methods are *slightly* different when used directly from
> CurrentDB. As opposed to from the dimensioned db.
>
> As an example:
> If you do a currentdb.execute("Delete * xyz) you will not get an error
> message
>
> But you will if it has been dimmed.
>
> Am I right?  Might be a bit confused..getting late and on my second
> half-pint of the week.
>
>