[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