Communication between DBF and MDB files

This forum is for eXpress++ general support.
Post Reply
Message
Author
Diego Euri Almanzar
Posts: 183
Joined: Thu Nov 05, 2020 10:51 am
Location: DOMINICAN REPUBLIC

Communication between DBF and MDB files

#1 Post by Diego Euri Almanzar »

Greetings, dear friends

Is there a redistributable component, a driver, for the Microsoft Access MDB database engine that can be handled by Xbase and transfer data to a DBF file, or vice versa?

I would appreciate your help.

User avatar
Tom
Posts: 1303
Joined: Thu Jan 28, 2010 12:59 am
Location: Berlin, Germany

Re: Communication between DBF and MDB files

#2 Post by Tom »

With the ODBCDBE and the "Microsoft Access Database"-driver (as the DSN name), you should be able to directly access the tables.
Best regards,
Tom

"Did I offend you?"
"No."
"Okay, give me a second chance."

User avatar
rdonnay
Site Admin
Posts: 4875
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: Communication between DBF and MDB files

#3 Post by rdonnay »

The eXpress train is coming - and it has more cars.

Diego Euri Almanzar
Posts: 183
Joined: Thu Nov 05, 2020 10:51 am
Location: DOMINICAN REPUBLIC

Re: Communication between DBF and MDB files

#4 Post by Diego Euri Almanzar »

I'm developing an employee payroll system where employee identification for clocking in and out is based on each person's fingerprint. I couldn't find a fingerprint DLL for Xbase++, so I had to use another language to capture the fingerprints, associated with a fingerprint reader, of course. Since the language used for fingerprint capture doesn't work with DBF files, it at least offers an MDB option.

And thanks to you, Tom and Roger, I've already integrated everything via ODBC. Furthermore, MDB tables can include OLE object fields, which are used to embed or link files from other applications, such as Excel spreadsheets, Word documents, or images (for example, fingerprint). In short, with these tools and your help, everything turned out perfectly.

Thank you very much.

User avatar
Tom
Posts: 1303
Joined: Thu Jan 28, 2010 12:59 am
Location: Berlin, Germany

Re: Communication between DBF and MDB files

#5 Post by Tom »

Great! :)
Best regards,
Tom

"Did I offend you?"
"No."
"Okay, give me a second chance."

User avatar
unixkd
Posts: 625
Joined: Thu Feb 11, 2010 1:39 pm

Re: Communication between DBF and MDB files

#6 Post by unixkd »

Take a look at innovatrics fingerprint sdk. It is very versatile and easy to use

Post Reply