I am creating an HR application. I have a field for biometric data (Finger Print) and another for picture.

How do I put such records or data in Microsoft Access?

Generally speaking you wouldn't want to -- the database would get very large, very fast.  And once it hits (2gb I think), it won't be able to be opened on different computer systems.

Generally with picture-like information you only store the link to the picture in the database.


Otherwise... you end up reading/storing the picture as a binary thing (or storing the image from a image/picture control) into a blob-like field (can't remember Access's name for it).

Microsoft has an example that would have to be modified (it uses a sql server, but it's still basically the same):
http://msdn.microsoft.com/en-us/library/ms678200(VS.85).aspx


[Edited by JLRodgers on 14-05-2008 at 09:16 AM GMT]

____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)