Error 3048: more databases is not possible to open

[TNL]

Hi,
I habe a Access 2k program, that links to many tables from 3 others access
databases.

After a certain amount of actions (cca 10x open a form) I receive an error:
Errornumber: 3048
Description: It is unpossible to open more databases

This error occurs repeatly and always at codelines, where a recordset is
opened or where a recordsource property of a form is set.

I must restart program (db), then I can execute 10 operations. And...

Why? What can I do?
Thanks for help.

Thanh-Nhan Le

 

[Pieter Wijnen]

always make sure to close recordsets after you're done with them
access can only have a limited number of handles open at the same time
union queries will for instance open 1 connection fotr each select

so if you have

dim rs as recordset

set rs=currentdb.openrecordset(....)
......

' always do this
rs.close : set rs = nothing


HTH

Pieter

 

[TNL]

I close always a recodset explicitly.
I have found the reason: my forms weren't not closed, were only set
unvisible. Each forms opens some tables.

Thanks,
Thanh-Nhan Le