2 Gig limit on an Access DB will fill up very quickly when using attachment data type
in [General]
|
From: Roger on 30 Mar 2010 01:40 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
From: PieterLinden via AccessMonster.com on 30 Mar 2010 02:26 Roger wrote: >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 Upsizing is one option. Then use Access as a front end. Requires some rewriting, though, because SQL Server has features that Access doesn't... Otherwise, you would have to store the files in a directory that everyone has access to and then use hyperlinks. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access/201003/1
From: Roger on 30 Mar 2010 02:47 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 "PieterLinden via AccessMonster.com" <u49887(a)uwe> wrote in message news:a5c4c3098facf(a)uwe... > Roger wrote: >>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 > > Upsizing is one option. Then use Access as a front end. Requires some > rewriting, though, because SQL Server has features that Access doesn't... > Otherwise, you would have to store the files in a directory that everyone > has > access to and then use hyperlinks. > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access/201003/1 >
From: Tom van Stiphout on 30 Mar 2010 07:12 On Tue, 30 Mar 2010 17:47:02 +1100, "Roger" <roger(a)speedy.net.au> wrote: 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 >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 > >"PieterLinden via AccessMonster.com" <u49887(a)uwe> wrote in message >news:a5c4c3098facf(a)uwe... >> Roger wrote: >>>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 >> >> Upsizing is one option. Then use Access as a front end. Requires some >> rewriting, though, because SQL Server has features that Access doesn't... >> Otherwise, you would have to store the files in a directory that everyone >> has >> access to and then use hyperlinks. >> >> -- >> Message posted via AccessMonster.com >> http://www.accessmonster.com/Uwe/Forums.aspx/access/201003/1 >>
|
Pages: 1 Prev: hey Next: Multiple Where condition in Apply Filter command |