pictures in access 2000 (1 Viewer)

J

jaybourne100

Guest

• Jan 20, 2005

• #1

hi i was just wondering.....
after inserting pictures into my database to improve the appearance the file size has grown. even after deleting many of the images the files size is still the same. do thye get stored in the file even if you dont use them?
if so how do i get rid of them

thanks

 

sfreeman@co.mer

Sam_F

Local time

Today, 12:52

Joined

Aug 2, 2004

Messages

272

• Jan 20, 2005

• #2

I suggest that you do not put them in there to begin with, that way no size issue.

Standard db design suggests that you store the images outside of the db and only store the path to the file.

Here is one way:

http://www.jamiessoftware.tk/articles/handlingimages.html

Also, check the MS site for more info.

 

Oldsoftboss

AWF VIP

Local time

Tomorrow, 05:52

Joined

Oct 28, 2001

Messages

2,499

• Jan 21, 2005

• #3

Like this ???

http://www.access-programmers.co.uk/forums/showthread.php?t=62251&highlight=image

 

J

jaybourne100

Guest

• Jan 21, 2005

• #4

ok thanks ill give it a go

 

neileg

AWF VIP

Local time

Today, 20:52

Joined

Dec 4, 2002

Messages

5,975

• Jan 21, 2005

• #5

jaybourne100 said:

even after deleting many of the images the files size is still the same.

Click to expand...

Run Repair & Compact. This should shrink your file back again.

 

sfreeman@co.mer

Sam_F

Local time

Today, 12:52

Joined

Aug 2, 2004

Messages

272

• Jan 22, 2005

• #6

I agree that you should compact and repair, but I do not believe that the files themselves will shrink appreciably. I am not aware of any advantage to store them within the database.

 

ChrisO

Registered User.

Local time

Tomorrow, 05:52

Joined

Apr 30, 2003

Messages

3,202

• Jan 22, 2005

• #7

Actually, there are valid reasons for storing image files within a database and that goes for any other file as well.

What it really boils down to is size, distance from customer, ability of customer to effect changes to files correctly, registration of files, how the files are stored, security of such files and if the files are stored in the BE or FE, or indeed, a separate database in the BE or FE directory.

The generally accepted practice is don’t store files but there are too many exceptions that make the general acceptance somewhat tenuous.