<div>
Hi,<br />
try to use RecordSetClone method for performing multiple<br />
requeries on form.<br />
<br />
<br />

</div>


Hi,
try to use RecordSetClone method for performing multiple
requeries on form.




<div>
Just noticed that it was databases, not tables. &nbsp;What I said still applies in regards to the code however. &nbsp;When you open an ADO recordset, how are you doing it?<br />
<br />
Jim.
</div>


Just noticed that it was databases, not tables.  What I said still applies in regards to the code however.  When you open an ADO recordset, how are you doing it?

Jim.

<div>
 for lwoessner <br />
<br />
No comment has been added for the last two months.<br />
So it's time to clean up this TA.<br />
I will leave a recommendation in Community Support that this question is:<br />
&nbsp;- PAQ'd and pts removed<br />
Please leave any comments here within the <br />
next seven days.<br />
<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !<br />
<br />
Nic;o)
</div>


for lwoessner

No comment has been added for the last two months.
So it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
 - PAQ'd and pts removed
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)

<div>
<div class="content wysiwyg-content">
I get Error 3048 (&quot;Can't open any more databases&quot;)after perfoming multiple requeries on a form in Access 97. The form is based on a query &nbsp;from a linked table. Requery works a number of times (approx 20) before giving this message.Can anyone tell me why, and what I can do to fix it?<br />
<br />
Thanks,<br />
lwoessner
</div>
</div>


I get Error 3048 ("Can't open any more databases")after perfoming multiple requeries on a form in Access 97. The form is based on a query  from a linked table. Requery works a number of times (approx 20) before giving this message.Can anyone tell me why, and what I can do to fix it?

Thanks,
lwoessner

Access 97 Error 3048

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.