Resume Database and PDF's

[eBradleyGT via AccessMonster.com]

I am relatively new to Access, and not particulary good at coding however, I
have been put in charge of creating an MS Access database for the Resume's my
company receives (We not a very large company so this task shouldn't be too
overwhelming). My thought was to have a table of the basic information i.e.
name position applied for contact info...etc, and then I wanted to attach a
scanned pdf copy of the applicants resume in with their information in the Db.
As an end result I would like to have a form which displays the applicants
basic info and then a button to view their resume should the manager wish to
learn more about them....Any help you can provide would be greatly
appreciated.

 

[John W. Vinson]

I am relatively new to Access, and not particulary good at coding however, I
have been put in charge of creating an MS Access database for the Resume's my
company receives (We not a very large company so this task shouldn't be too
overwhelming). My thought was to have a table of the basic information i.e.
name position applied for contact info...etc, and then I wanted to attach a
scanned pdf copy of the applicants resume in with their information in the Db.
As an end result I would like to have a form which displays the applicants
basic info and then a button to view their resume should the manager wish to
learn more about them....Any help you can provide would be greatly
appreciated.

In A2003 and earlier versions, it's best NOT to store graphical images in
tables - they are handled VERY inefficiently. It's better in 2007, but scanned
images are still very large and can quickly fill up the 2 GByte capacity of a
database.

I'd suggest storing the images (as .pdf files) in a known folder on your
computer (a shared folder if this is a multiuser system) and store the full
path and filename in a Text or Hyperlink field in your table. The text field
is a bit easier to enter, the Hyperlink a bit easier to use (just click on the
filename and Adobe should open the file); with the text file you can easily
write some VBA code to open the file.

John W. Vinson [MVP]