Error 3048 when setting a recordset RRS feed

  • Question

  • I have developed a rather large access+vba application that includes a Module which can be opened following two different menu paths. Following the shorter  path there is no problem, while through the other path, at a "Set Recordset" statement, suffers unexplenable Error 3048 "Cannot open any more databases".

    Could it be memory limitation problem?

    Monday, September 11, 2017 2:57 PM

All replies

  • If it's an Access database then it's a limit to the number open tables (table IDs) which is 2048. I do not know how your database has been designed, but perhaps some of your queries are too large or you have many queries or tables opened by the forms or code in your application.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    Monday, September 11, 2017 10:15 PM