Access is too big! how to reduce size? (1 Viewer)

Rambo1982

New member
Local time
Yesterday, 23:29
Joined
Nov 30, 2005
Messages
6
Hi, i am wondering how to reduce the size of access.
i have included pictures within forms which obviously made the database bigger (it is currently around 12mb).
However i have tried to delete the pictures to reduce the size, this method did not work at all. The database remains the same size.
does anyone have any suggestions on how to solve this problem i am having?

thanks

Pete
 
Last edited:

locomotion

Registered User.
Local time
Today, 17:29
Joined
Dec 7, 2005
Messages
25
Use the compact database wizard in the tool menu

Also you could try splitting the database and keep the tables in one place and the forms in another

Hope this helps

/locomotion
 

Rambo1982

New member
Local time
Yesterday, 23:29
Joined
Nov 30, 2005
Messages
6
thanks, ill try it. but i really want to keep it all in one place.

any other ideas?
 

seth_belgium

WoW-Addict
Local time
Today, 07:29
Joined
Oct 4, 2005
Messages
175
Isn't there a way to actually place the images in a directory somewhere on you HD so that access only displays the image instead of storing it in your database?
 

jrjr

A work in progress
Local time
Today, 02:29
Joined
Jul 23, 2004
Messages
291
Change the pictures from embedded to linked. After making the changes then do your compact and repair. That will remove any voids and reduce the size of your db.
 

locomotion

Registered User.
Local time
Today, 17:29
Joined
Dec 7, 2005
Messages
25
some data validation rules might be a good idea

Somethings you might want to try are:

Digits in phone numbers (Australia has 10)

Postal Codes (Australia has 4)

if its values work out how much is the greatest value going to be

use data validation rules

make sure that all your data is acurate

put in some data imput masks to make sure that formatting is correct

Try getting some more storage space?!?
 

Rambo1982

New member
Local time
Yesterday, 23:29
Joined
Nov 30, 2005
Messages
6
Thanks guys!!!
Yea ive linked the pictures, it has made it a whole lot easier to transfer and handle the database now.

Thanks again
 

Users who are viewing this thread

Top Bottom