473,326 Members | 2,048 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Huge file size

I'm building a table and form which includes a photograph. The image size
of each photograph is about 50k. There are going to be about 500 records.
I have so far linked a photograph to the first 50 records and the saved
file is over 500Mg. Is there a better way of doing this? I have already
compacted the database and it makes no difference to its size.

Thank you

Nigel Ball
Nov 12 '05 #1
9 4080
On Sun, 5 Oct 2003 10:53:31 +0100 in comp.databases.ms-access, "Nigel
Ball" <nb*@blueyonder.co.uk> wrote:
I'm building a table and form which includes a photograph. The image size
of each photograph is about 50k. There are going to be about 500 records.
I have so far linked a photograph to the first 50 records and the saved
file is over 500Mg. Is there a better way of doing this? I have already
compacted the database and it makes no difference to its size.


A jpeg may be small on the disk but it's compressed, when you shove
one into a database it will store not only the jpeg but a bitmap
representation as well. It shouldn't do as you're linking rather than
embedding but it shows how really poor databases are at images.

What I do is store the path to a picture in a text field, an example
is here:
http://www.trevor.easynet.co.uk/downloads/Images.zip

--
A)bort, R)etry, I)nfluence with large hammer.
Nov 12 '05 #2
store the PATH to the picture file. Just put all the pictures in a
directory on the same machine as the backend... otherwise, yes, your
database is going to get huge. Larry Linson has a FAQ on all that
somewhere...
Nov 12 '05 #3
On 05 Oct 2003 Trevor Best <bouncer@localhost> wrote in
news:c9********************************@4ax.com:

[storing pictures in a db]
What I do is store the path to a picture in a text field, an
example is here:
http://www.trevor.easynet.co.uk/downloads/Images.zip


Sounds like a solution to what I'm trying to do at the moment.
Unfortunatly I can't open the db in that archive as it says it is saved
in a later version that what I'm using (2000). Would it be possible for
you to convert it back and then either put it on the web again or e-
mail it to me?

On a different, but related, note, how do you put something on a form
to allow people to browse through their disk to find the file they
want?

--
Graham Drabble
If you're interested in what goes on in other groups or want to find
an interesting group to read then check news.groups.reviews for what
others have to say or contribute a review for others to read.
Nov 12 '05 #4
On Sun, 05 Oct 2003 14:46:11 +0100 in comp.databases.ms-access, Graham
Drabble <gr************@lineone.net> wrote:
Sounds like a solution to what I'm trying to do at the moment.
Unfortunatly I can't open the db in that archive as it says it is saved
in a later version that what I'm using (2000). Would it be possible for
you to convert it back and then either put it on the web again or e-
mail it to me?
sure, no problem :-)
http://www.trevor.easynet.co.uk/down...Images2000.zip
On a different, but related, note, how do you put something on a form
to allow people to browse through their disk to find the file they
want?


You mean the file open dialog? It's in that database, in module
basOpenFileDlg and is called from the main form.

--
A)bort, R)etry, I)nfluence with large hammer.
Nov 12 '05 #5
Graham Drabble <gr************@lineone.net> wrote in message

On a different, but related, note, how do you put something on a form
to allow people to browse through their disk to find the file they
want?


Use the FileOpen code at mvps.org Ken Getz wrote it, so look for his name...
Nov 12 '05 #6
On 05 Oct 2003 Trevor Best <bouncer@localhost> wrote in
news:m6********************************@4ax.com:
On Sun, 05 Oct 2003 14:46:11 +0100 in comp.databases.ms-access,
Graham Drabble <gr************@lineone.net> wrote:
Sounds like a solution to what I'm trying to do at the moment.
Unfortunatly I can't open the db in that archive as it says it is
saved in a later version that what I'm using (2000). Would it be
possible for you to convert it back and then either put it on the
web again or e- mail it to me?


sure, no problem :-)
http://www.trevor.easynet.co.uk/down...Images2000.zip


Thanks.
On a different, but related, note, how do you put something on a
form to allow people to browse through their disk to find the file
they want?


You mean the file open dialog? It's in that database, in module
basOpenFileDlg and is called from the main form.


That's exactly what I wanted. Many thanks. My 30MB database just
shrank to 9.5MB using paths rather than OLE.

--
Graham Drabble
If you're interested in what goes on in other groups or want to find
an interesting group to read then check news.groups.reviews for what
others have to say or contribute a review for others to read.
Nov 12 '05 #7
On 05 Oct 2003 Trevor Best <bouncer@localhost> wrote in
news:m6********************************@4ax.com:
On Sun, 05 Oct 2003 14:46:11 +0100 in comp.databases.ms-access,
Graham Drabble <gr************@lineone.net> wrote:
Sounds like a solution to what I'm trying to do at the moment.
Unfortunatly I can't open the db in that archive as it says it is
saved in a later version that what I'm using (2000). Would it be
possible for you to convert it back and then either put it on the
web again or e- mail it to me?


sure, no problem :-)
http://www.trevor.easynet.co.uk/down...Images2000.zip


I've just realised that I broke a report doing this. The paths are
for scans of signiturs that can be used on certificates. Not everyone
has a signiture scanned so it can be null.

What I've got is a report showing all the adults. As part of that I
want to show the signitures for those that had them. With the OLE
field that was easy, I simply used a Bound Object Frame. With this
method I can't do it.

The table is called 'leaders' and the field 'SignitureFile'. What
I've tried so far is to put a picture object (called 'pic') in the
report with (none) in the Picture attribute. I'm then going to set
pic.picture using OnOpen.

Private Sub Report_Open(Cancel As Integer)
pic.Picture = [SignitureFile]
End Sub

Gives the error

"Run error 2465

Can't find the field SignitureFile referred to in your expression
"

I also have a text box on the report called "SigFile" that has =IIf
([SignitureFile],[SignitureFile],"(none)") as a Control Source.

Private Sub Report_Open(Cancel As Integer)
pic.Picture = [SigFile]
End Sub

gives

"Run Time error 13

Type mismatch
"

and

Private Sub Report_Open(Cancel As Integer)
pic.Picture = "'" & [SigFile] & "'"
End Sub

gives

"Run time error 2427

You entered an expression that has no value"

Any suggestions as to the right way of doing this would be gratefully
accepted.

--
Graham Drabble
If you're interested in what goes on in other groups or want to find
an interesting group to read then check news.groups.reviews for what
others have to say or contribute a review for others to read.
Nov 12 '05 #8


If there is no control bound to a field in a report then sometimes Access skips retrieving the data. Try
binding a text control to the field (you can hide this control).
--
__________________________________________________ _____
http://www.ammara.com/
Image Handling Components, Samples, Solutions and Info

Graham Drabble <gr************@lineone.net> wrote:
On 05 Oct 2003 Trevor Best <bouncer@localhost> wrote in
news:m6********************************@4ax.com :
On Sun, 05 Oct 2003 14:46:11 +0100 in comp.databases.ms-access,
Graham Drabble <gr************@lineone.net> wrote:
Sounds like a solution to what I'm trying to do at the moment.
Unfortunatly I can't open the db in that archive as it says it is
saved in a later version that what I'm using (2000). Would it be
possible for you to convert it back and then either put it on the
web again or e- mail it to me?


sure, no problem :-)
http://www.trevor.easynet.co.uk/down...Images2000.zip


I've just realised that I broke a report doing this. The paths are
for scans of signiturs that can be used on certificates. Not everyone
has a signiture scanned so it can be null.

What I've got is a report showing all the adults. As part of that I
want to show the signitures for those that had them. With the OLE
field that was easy, I simply used a Bound Object Frame. With this
method I can't do it.

The table is called 'leaders' and the field 'SignitureFile'. What
I've tried so far is to put a picture object (called 'pic') in the
report with (none) in the Picture attribute. I'm then going to set
pic.picture using OnOpen.

Private Sub Report_Open(Cancel As Integer)
pic.Picture = [SignitureFile]
End Sub

Gives the error

"Run error 2465

Can't find the field SignitureFile referred to in your expression
"

I also have a text box on the report called "SigFile" that has =IIf
([SignitureFile],[SignitureFile],"(none)") as a Control Source.

Private Sub Report_Open(Cancel As Integer)
pic.Picture = [SigFile]
End Sub

gives

"Run Time error 13

Type mismatch
"

and

Private Sub Report_Open(Cancel As Integer)
pic.Picture = "'" & [SigFile] & "'"
End Sub

gives

"Run time error 2427

You entered an expression that has no value"

Any suggestions as to the right way of doing this would be gratefully
accepted.

--
Graham Drabble
If you're interested in what goes on in other groups or want to find
an interesting group to read then check news.groups.reviews for what
others have to say or contribute a review for others to read.


Nov 12 '05 #9
On Mon, 06 Oct 2003 12:02:18 +0100 in comp.databases.ms-access, Graham
Drabble <gr************@lineone.net> wrote:
Private Sub Report_Open(Cancel As Integer)
pic.Picture = [SignitureFile]
End Sub

Gives the error

"Run error 2465

Can't find the field SignitureFile referred to in your expression
Try the relevant section's print event.
I also have a text box on the report called "SigFile" that has =IIf
([SignitureFile],[SignitureFile],"(none)") as a Control Source.

Private Sub Report_Open(Cancel As Integer)
pic.Picture = [SigFile]
End Sub

gives

"Run Time error 13

Type mismatch


=IIf(Len("" & [SignitureFile]),[SignitureFile],"(none)")
--
A)bort, R)etry, I)nfluence with large hammer.
Nov 12 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Joe | last post by:
I have an upload file operation in the web application. UploadForm.asp is the form, and UploadAction.asp is the form processing. //UploadForm.asp <FORM NAME="InputForm"...
2
by: Zam | last post by:
Hello World, Under Windows 2003 Server. IIS6. The following code working fine for small files, and for files with size about few megabytes. If I am trying to send HUGE file -- about 700...
10
by: joe | last post by:
hi, I have to import a huge xml file into our system. the problem is that the xml source can be larger than 2GB. I wanted to use the XmlTextReader class for this purpose but it's limited to 2GB...
6
by: Daniel Walzenbach | last post by:
Hi, I have a web application which sometimes throws an “out of memory” exception. To get an idea what happens I traced some values using performance monitor and got the following values (for...
2
by: azemerov | last post by:
Hi, I build my C++ project (windows DLL) with GNU C and Borland C++. Everything is fine except huge difference in resulting DLL file size. GNU C procuces almost 10 times larger file than Borland...
5
by: Naamat | last post by:
Hello, I am the sample FPSEPublish (http://blog.baeke.info/blog/_archives/2005/3/3/393158.html) code to upload a document to Sharepoint (WSS). This works perfectly for samll documents. ...
12
by: Jeff Calico | last post by:
I have 2 XML data files that I want to extract data from simultaneously and transform with XSLT to generate a report. The first file is huge and when XSLT builds the DOM tree in memory, it runs...
9
by: BlackMagic | last post by:
I am writing a program in C to parse binary data files in excess of 4 GB. They could conceivably be up to 2 Terabytes long. I am using fopen and fread to do the file io. I am compiling right now...
3
by: tejsupra | last post by:
Hello Everyone, I need to read a .csv file which has a size of 2.26 GB . And I wrote a Python script , where I need to read this file. And my Computer has 2 GB RAM Please see the code as...
11
by: DanicaDear | last post by:
I have searched around the net breifly over the last few weeks trying to figure out why Access file sizes increase so dramatically when you put your logo on forms/reports. I haven't found much on...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shllpp 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.