Using Access to link to files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to set up a simple Access Database to manage our correspondence
and spreadsheet files related to differetn properities we own. My plan is to
use the hyperlink function to allow people to locate files on our server.
Additionally, I thought we'd have someone copy email correspondence to a
correspondence table (with PersonName, PropertyID, CorrespondenceType,
Comment, and Date fields) which could be referenced under a form for each
property.

Does anyone have any experience doing this sort of thing? Is Access a good
way to manage this kind of correspondence? Things I should keep in mind as I
build the database? Thanks! Jim
 
you should throw MDB out the window; and learn DTS or some real tool.

if you care enough about your data to build a database; use SQL Server.

MDB is just a speedbump on thw way to a real DB.
 
you should throw MDB out the window; and learn DTS or some real tool.

if you care enough about your data to build a database; use SQL Server.

MDB is just a speedbump on thw way to a real DB.
 
Back
Top