attachments / performance / access 2007

[bml337 via AccessMonster.com]

Im using access 2007... my database needs to manage employee documents which
are scanned and saved in a pdf format. My question, does saving the pdf in
the database effect the performance or just the size of the database? I have
a few hundred employees, who have multiple documents to track... so the size
of the db can easily get pretty big. Obviously HD space is not an issue,
just performance. Is it better to point to the file location on the server
(i prefer not).

thanks

bl

 

[Guest]

Just remember that Access has a 2GB limit for each mdb file. So, storing the
documents will make the database get to that limit much faster than storing
the paths.

Performance may be affected by the storage, depending on how you use them.
--
Bob Larson
Access World Forums Super Moderator
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista