Access 07 attachments

[Dave]

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.

 

[TedMi]

Access files (mdb or accdb) are limited to 2GB. Corruption results can
result when that limit is approached.
-TedMi

 

[Dave]

Thanks Ted, I figgured as much. I really thought it was 4gb with access 07
though... Sigh

 

[Dave]

How would you go about increasing the size available? export to sql?
SHarepoint?
split it between more db?

 

[John W. Vinson]

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.

 

[Dave]

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.