Access timeout?

  • Thread starter Thread starter VB Programmer
  • Start date Start date
V

VB Programmer

Is there something in the connection string that will timeout a MS Access
connection if left open? The ldb doesn't ever seem to disappear, even no
one is using the file.

Thanks!
 
Hi

You mean conn.close, however keep in mind that while it normally the best to
do, that you can beter not do that in my opinion with a winform application
wich uses a Access database.

I hope this helps?

Cor
 
Thanks Cor, as usual.

In case I miss a conn.close is there a timeout param in the connection
string that I can use?

Thanks!
 
¤ Is there something in the connection string that will timeout a MS Access
¤ connection if left open? The ldb doesn't ever seem to disappear, even no
¤ one is using the file.

No, the Jet database engine does not support a feature such as this.

You may want to check out the following MS KB article as well:

ACC: Introduction to .ldb Files (95/97)
http://support.microsoft.com/default.aspx?scid=kb;en-us;136128


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top