Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #13575

Re: Way to identify open processes?

Show all headers | View raw

On 4/3/2019 1:41 PM, Ron Paii wrote:
> This is a solution that you can try from VBA. I have't tried it in production but it seems to work and you only need access to the BE file (no admin). You will need to set a reference to "Microsoft ActiveX Data Objects 6.1 Library", push it's priority to the bottom or use DAO.Recordset when defining DAO objects in your code.
> 
(snipped for brevity)

Thanks again! One thing that caught my eye is:
>      
>      If fileToCheck <> vbNullString Then
>          If FileExt(fileToCheck) = "accdb" Then
>              cn.Provider = "Microsoft.ACE.OLEDB.12.0"   ' accdb
>          ElseIf FileExt(fileToCheck) = "mdb" Then
>              cn.Provider = "Microsoft.Jet.OLEDB.4.0"    ' mdb
>  
This implies a change in how OLEDB versions handle the different 
database formats. I didn't see any specific reference to that when I was 
updating the format from .mdb to .accdb in any of the driver references.

I did follow recommendations to stay with the more Access-specific 
"Microsoft Access Driver" and ADODB due to there being fewer layers and 
thus faster operation than OLEDB. Indeed, everything does run quickly 
and properly except for the lock files (.laccdb). If there's a quirk in 
the way it handles .accdb and .mdb file locking, that may be the source 
of my problems.

I also downloaded the sysinternalsSuite, but for some reason none of the 
.CHM files provided search results as they usually do (I didn't run any 
.exe files to see if that made a difference). The PDF file on the page 
was also invalid, and couldn't be opened. That would make it rather 
difficult to use without buying and studying one of the recommended books.

Any insights are appreciated!

-- 
best regards,

Neil

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Way to identify open processes? Neil <neil@myplaceofwork.com> - 2019-04-03 06:44 -0400
  Re: Way to identify open processes? Ron Paii <ron81pai@gmail.com> - 2019-04-03 05:07 -0700
    Re: Way to identify open processes? Neil <neil@myplaceofwork.com> - 2019-04-03 10:00 -0400
      Re: Way to identify open processes? Ron Paii <ron81pai@gmail.com> - 2019-04-03 10:41 -0700
        Re: Way to identify open processes? Neil <neil@myplaceofwork.com> - 2019-04-03 15:54 -0400
          Re: Way to identify open processes? Ron Paii <ron81pai@gmail.com> - 2019-04-03 13:58 -0700

csiph-web