how optimize a acess db connection?
hi,
i have used a file monitor to see what the programs do an di see a program that use the same db that i use in my project and he read the db each 5 segunds with my current connection my program read in each 2 segunds
for other words my connection is not optimized so is a waste of cpu and resources if my program is read the db in less interval my current connection string is that:
x.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & path & ";", "", ""
.CursorLocation = adUseClient
.open sSQL2, sConnection, adOpenKeyset, adLockReadOnly 'adLockOptimistic
thanks for your help:)