Access timeout?

[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!

 

[Cor Ligthert]

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

 

[VB Programmer]

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!

 

[Cor Ligthert]

You can maybe use the timeout in the command

http://msdn.microsoft.com/library/d...oledboledbcommandclasscommandtimeouttopic.asp

I hope this helps?

Cor

 

[Paul Clement]

¤ 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)