Access photo database

[Martin Mosley]

I am a new user of Access and wish to develop a database
for my photograph collection which i have digitised. can
anyone help please?

 

[PC Datasheet]

Store your photographs in a folder. Set up a table like this:
TblMyPhotograph
MyPhotographID
MyPhotographPath
PhotographDate
Description

Where MyPhotographPath is the path to the photograph:
C:\MyPhotographs\Photo1.bmp

Add a hidden textbox named PhotographPath on your form and set its control
source to
MyPhotographPath.

Use an image control named MyPhotograph from the toolbox to display photos on a
form.

Put the following code in the OnCurrent event of the form:
Me!MyPhotograph.Picture = Me!PhotographPath