Are Attachments bad?

[BrookieOU]

I would like to add an attachment field to attach a .pdf scan of Purchase
Orders we receive to the project they go with. Eventually the database will
grow pretty large (currently it has only 200 projects) and I was wondering if
adding all these attachments will cause it to slow down considerably?

Thanks,
Brooke

 

[John W. Vinson]

I would like to add an attachment field to attach a .pdf scan of Purchase
Orders we receive to the project they go with. Eventually the database will
grow pretty large (currently it has only 200 projects) and I was wondering if
adding all these attachments will cause it to slow down considerably?

Thanks,
Brooke

Yes, and it will cause the database to grow until it hits the size limit of
2GByte. It will then become unusable.

I would suggest either storing the .pdf files in a directory and putting only
the filename and path in your Access table, or migrating your backend to
SQL/Server (which can handle far larger databases).