making access database smaller

G

Guest

hi,

I was wondering how can I make my access database smaller. i have look at
changing the field size but that does not help.

Any comments is appreciated. The file size now approaching 70 Mb with out
any data mostly in there is a graphic file should I be looking at deleting
the graphic or what??

Thanks
 
A

Allen Browne

Yes, deleting the graphic will make a big difference.

Don't forget to compact the database (Database Utilities on the Tools menu.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difference in size of actual access database and its backup 0
Splitting an Access Database into fe/be-b'cuz db too large 1.65 gi 10
Reducing Database Size 4
Redesign of an old Access Database with Linked Tables 4
deletting data from access database 1
Table size error message 2
Making a Database for 14,000 providers in Access 97 need resources 18
Access 2003 shutdown question 1

Top