If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 07 attachments
I have an access 07 database that I attach PDF files to. So far it has
worked fine until recently it started giveing me error when i try to attach more files it says error , database is corrupt or of unknown file type. Is there a size limit in the amount of the attachemts? or size of the back end? the file size of the BE is over 2 gb. 2,095,652kb to be exact. |
#2
|
|||
|
|||
Access 07 attachments
Access files (mdb or accdb) are limited to 2GB. Corruption results can
result when that limit is approached. -TedMi "Dave" wrote in message ... I have an access 07 database that I attach PDF files to. So far it has worked fine until recently it started giveing me error when i try to attach more files it says error , database is corrupt or of unknown file type. Is there a size limit in the amount of the attachemts? or size of the back end? the file size of the BE is over 2 gb. 2,095,652kb to be exact. |
#3
|
|||
|
|||
Access 07 attachments
Thanks Ted, I figgured as much. I really thought it was 4gb with access 07
though... Sigh "TedMi" wrote: Access files (mdb or accdb) are limited to 2GB. Corruption results can result when that limit is approached. -TedMi "Dave" wrote in message ... I have an access 07 database that I attach PDF files to. So far it has worked fine until recently it started giveing me error when i try to attach more files it says error , database is corrupt or of unknown file type. Is there a size limit in the amount of the attachemts? or size of the back end? the file size of the BE is over 2 gb. 2,095,652kb to be exact. |
#4
|
|||
|
|||
Access 07 attachments
How would you go about increasing the size available? export to sql?
SHarepoint? split it between more db? "TedMi" wrote: Access files (mdb or accdb) are limited to 2GB. Corruption results can result when that limit is approached. -TedMi "Dave" wrote in message ... I have an access 07 database that I attach PDF files to. So far it has worked fine until recently it started giveing me error when i try to attach more files it says error , database is corrupt or of unknown file type. Is there a size limit in the amount of the attachemts? or size of the back end? the file size of the BE is over 2 gb. 2,095,652kb to be exact. |
#5
|
|||
|
|||
Access 07 attachments
On Tue, 24 Feb 2009 12:00:18 -0800, Dave
wrote: How would you go about increasing the size available? export to sql? SHarepoint? The simplest way would be to not store the pdf files in your database at all; instead just store a text field with the filename, or path and filename, and store the pdf files externally to the database. You could have code to get the filenames and launch the pdf viewer. -- John W. Vinson [MVP] |
#6
|
|||
|
|||
Access 07 attachments
Thanks John, I was thinking about this yesterday. I did however upgrade the
backend to sql. is there a way to use file path name \\server\folder\ to open the file I need to point to? I dont know any VBA. "John W. Vinson" wrote: On Tue, 24 Feb 2009 12:00:18 -0800, Dave wrote: How would you go about increasing the size available? export to sql? SHarepoint? The simplest way would be to not store the pdf files in your database at all; instead just store a text field with the filename, or path and filename, and store the pdf files externally to the database. You could have code to get the filenames and launch the pdf viewer. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|