[AccessD] OpenRecordSet question

Thanks Gustav.
I think the later posts from Stuart clarify the situation.
Back to good old CurrentDB then.
Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: 09 August 2009 11:36
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] OpenRecordSet question

Hi Max

A surprise is waiting you. Try to, say, create a table by calling another
function and read it from your db object; it isn't there until you do a
db.Refresh. So:

.. you ARE actually looking at the DB object as is when initialized or
refreshed - including subsequent changes made in the current context.

/gustav

>>> max.wanadoo at gmail.com 09-08-2009 12:03 >>>
Very interesting John,

FWIW my results hover around the 150 mark ??  DBENGINE is 1.

So, clearly the answer is to Set db = DBEngine(0)(0).  That way you will
know that you ARE actually looking at the DB as it exists and not as it DID
exist at the time when the object was created.

Thanks for the effort.

Max


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com