I know this is the VB world but I use Access along with VB. I have a database that starts off at about 10 meg in size. During the day I have about 6 users adding records. At the end of the day the DB is sitting at about 200 meg. I look to see how many records were added and it totals maybe 100. The record length is only 200 bytes. I then compact the database and it drops back down to about 2 or 3 meg more than it was before the day began. I am doing alot of SQL statements and updates to the records being entered. Any ideas? I have access to an Oracle system. If I link Access to the Oracle database, would that possibly stop the problem?

Thanks in advance.