2 Gig limit on an Access DB will fill up very quickly when using attachment data type

[Roger]

Hi,
I have an Access database with attachment data type enabled, as users are
uploading pdf's and other documents, I am afraid they will fill the database
(2GB) very quikly.
What are my options to resolve this?
Is there a way to continue using Access? do I need to Migrate to SQL? (does
SQL fix the problem? does it handle attachment data type?)

I wish there was a way to archive those attachements!

Regards
Roger

 

[Roger]

Thanks Pieter for your reply,

Does SQL have Attachment data type? I tried to do a test migration into SQL
the end result was that the attachment never came through into the SQL
database!

Regards
Roger

 

[Tom van Stiphout]

No. Rather you would store the path relative to some root folder, in a
varchar(255). Relative because that would make it much easier to move
your document folder or folder tree should the need ever arise.

SQL2008 also has interesting new "FILESTREAM Storage" - check it out
in Books Online.

-Tom.
Microsoft Access MVP