VBA Access: too many connections

  • Thread starter David Rodríguez Rincón
  • Start date
D

David Rodríguez Rincón

Hi all.

I have a problem with my application in VBA.

My ADE file is linked by default to a server/database. I don't know if it cannot be disabled and init the application disconnected (the connection string will be overwitten with user input).

The bigger problem is that, when the application starts, 2 connections are created (I guess Access manage automatically the connection because user input is not done yet) and later, when I want to open a linked form, another connection is generated.

Access is not using only the connection I set in the login form, and it create several ones to the same server/database (weird)

Anyone knows how to clear them and left only one connection per session?

Thanks in advance.

David Rodríguez
 

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

Top