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

  • Thread starter Thread starter Roger
  • Start date Start date
R

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
 
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
 
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
 
Back
Top