Can Access do the document tracking, etc

[dygku sophia]

i'm given a new task to create system that can track and register document (file and store document systematic).

the document that i register must can be view by all of engineer in our team.

**example: the engineer search some document, when they click to document title that i register, the document attachment automatic can be open and view by them.

what should i do?

[hvsummer]

I suggest you not to use attachment field of Access to do this.

better way, I think you can organize those document into a folder, then use Excel to store name/ID and hyperlink of those document so that your team can access to those file.

but I have to ask, your team is in the same local network or they're using internet ?
do you have any file server to store those file ? (you can google drive as an altenative)

what is the exactly detail work flow/process ?

[jforbes]

I would second that Access' Attachment mechanism not be used.

This is a previous thread related to working with attachments: https://bytes.com/topic/access/answe...nt-attachments

[zmbd]

better way, I think you can organize those document into a folder, then use Excel to store name/ID and hyperlink of those document so that your team can access to those file.

Please do NOT use Excel for something like this, follow the link that jforbes provided, TheSmileyCoder post there is the way to go, and some variation thereof is the way most if not many of use to track documents - both paper and electronic.

At one point in time, the location I work at was a small, independent facility and for the 30 or so documents we had in the lab for procedures were easily tracked by an Excel (well actually, it was Lotus123 when I started!!! ). Then we grew, and 30 went to 50 and so forth... yikes! I finally got them to move to a database, and eventually the company moved into one of the early Office suites -- yea! By then we had over 100 procedures to track.

And chemical inventories for the lab... yep... that started out as an Lotus123 file too... what a nightmare.

And we still have people tracking assets using excel workbooks. Every time they need an update, it takes days, weeks, and in one case I've been working on a file for over a year now - because that's the way they want the data. (a year... and not just myself but 5 other members of the lab staff spend hours going over this monster of a file).

Excel is not, nor was ever intended to be, a database program. good for small datasets... good for calculations... NOT good for maintaining, organizing, and manipulating data. IF it was, then every library on earth would base their circulation software on a spreadsheet!