If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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- |
#2
|
|||
|
|||
Decrease file size
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- |
#3
|
|||
|
|||
Decrease file size
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- . |
#4
|
|||
|
|||
Decrease file size
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... |
Thread Tools | |
Display Modes | |
|
|