{DATABASE} Field code for multiple databases

I

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database field code? 2
Mail Merge hyperlinks - Without ## 1
Auto Update Field Codes without Macros or F9? 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Access how to open existing database from another database using Access - VBA 0
Counting multiple memberships 1
database connection problem with Word 2003 tables 2
Can't create a report from my query in Access 1

Top