0

In my workplace the attendance (fingerprint) device uses .mdb file (that stored on Windows PC), and I have a smb account to the network share to that computer smb://10.7.7.x/tas/, inside the share folder contains 3 files:

 HITFPTA.ldb
 HITFPTA.mdb ==> this one
 HITFPTA_History.mdb

What are the easiest option to able to query (in real time) from that file, since our server that should do the query uses Linux (ArchLinux)? (if possible using Go programming language)

Kokizzu
  • 20,659
  • 24
  • 107
  • 195
  • Your server is Linux, but what about the machine(s) from which you will be querying the .mdb database? Are they Windows machines, something else, or a mix? – Gord Thompson Nov 26 '14 at 10:46
  • the `.mdb` is in Windows, the server is Linux, the client would be mix of both – Kokizzu Nov 26 '14 at 10:48
  • I need to access it (read and duplicate the data from the `.mdb` into our database in server, so it would be easier to produce the required report) – Kokizzu Nov 26 '14 at 10:49

1 Answers1

1

For read-only access to a "live" .mdb database from a mix of Windows and non-Windows clients I would recommend using Java and the UCanAccess JDBC driver (details here). If you're not keen on writing Java code but have some familiarity with Python then you could use Jython as described in my other answer here.

(Jackcess, the data-access layer used by UCanAccess, does not use the Access Database Engine and is not intended to make updates to a live multi-user database. However, it should be able to read the database without incident. For reporting purposes it might be prudent to take a copy of the .mdb file and run the reports against that. Or, stick with Windows clients and use ODBC.)

Community
  • 1
  • 1
Gord Thompson
  • 98,607
  • 26
  • 164
  • 342