Decrease file size

I am new to Access, but have developed a databases that currently has very few records (testing)... I do have over 8 tables and about the same number of forms and reprots. There are three queries. The database is showing that it is over 50mg. When I delete or change anything, it stays exactly the same size.

I need to post this to our corporate server. When I try, it takes over 30 minutes. It sure seems that something in the file size is incorrect. I am a novice, but any help would be appreciated...

Thanks-

You need to compact and repair the database.

Tools/Database Utilities/Compact and Repair


Rick B


"mgoldberg" wrote in message
...
I am new to Access, but have developed a databases that currently has very
few records (testing)... I do have over 8 tables and about the same number
of forms and reprots. There are three queries. The database is showing that
it is over 50mg. When I delete or change anything, it stays exactly the same
size.

I need to post this to our corporate server. When I try, it takes over 30
minutes. It sure seems that something in the file size is incorrect. I am a
novice, but any help would be appreciated...

Thanks-

You need to compact the database
go to
Tools/Database Utilities/Compact and Repair database

Jim

-----Original Message-----
I am new to Access, but have developed a databases that
currently has very few records (testing)... I do have over
8 tables and about the same number of forms and reprots.
There are three queries. The database is showing that it is
over 50mg. When I delete or change anything, it stays
exactly the same size.

I need to post this to our corporate server. When I try,
it takes over 30 minutes. It sure seems that something in
the file size is incorrect. I am a novice, but any help
would be appreciated...

Thanks-


.

Items that are deleted are still there until you compact the database. Go to
Tool|Database Utilities|Compact and Repair Database... You have to have
exclucisive access to the database file in order to compact.

Compacting is routine maintenance of a database. There are things you can do
to reduce the file size increase, but you can't eliminate it. Some of the
things you can do are to place temporary tables you create in a separate
file and delete it when you're done and limit repetitive adding and deleting
data from a table. If you have temporary tables, I recommend placing them in
the front-end, not the back-end file on the server. The back-end file should
be data storage only. Place a copy of the front-end file on each user's
computer.

--
Wayne Morgan
MS Access MVP


"mgoldberg" wrote in message
...
I am new to Access, but have developed a databases that currently has very
few records (testing)... I do have over 8 tables and about the same number
of forms and reprots. There are three queries. The database is showing that
it is over 50mg. When I delete or change anything, it stays exactly the same
size.

I need to post this to our corporate server. When I try, it takes over 30
minutes. It sure seems that something in the file size is incorrect. I am a
novice, but any help would be appreciated...