{DATABASE} Field code for multiple databases

[Ian McKeag]

I am using the DATABASE field code to insert data from an Access table which
is fine.. However, I am using two of these, which opens the DB for both,
leaving two instances of the same DB open.

Is there anyway to only open the database once for both queries or even not
at all?

Muchos gracias,
Ian McKeag

 

[Peter Jamieson]

Reply posted to your later version/duplicate of this question.

Peter Jamieson

http://tips.pjmsn.me.uk