Size of acess dbf files

I am currently creating a small ms-access data base, about 10 tables each with about 10 records, these have
to link to forms, which have command buttons and macros, any idea how large this file should get? as my
floppy seems to be too small to store it !!

Fortune Iroha

"Fortune" wrote in message
...
I am currently creating a small ms-access data base, about 10 tables each
with about 10 records, these have
to link to forms, which have command buttons and macros, any idea how
large this file should get? as my
floppy seems to be too small to store it !!

Fortune Iroha
Hi,
Go to Tools- Database utilities - Compress
This will reduce it as much as it can.
If it still won't fit on a floppy - zip it. (Pkzip or winzip)
Marc

On Wed, 19 May 2004 02:21:07 -0700, "Fortune"
wrote:

I am currently creating a small ms-access data base, about 10 tables each with about 10 records, these have
to link to forms, which have command buttons and macros, any idea how large this file should get? as my
floppy seems to be too small to store it !!

Fortune Iroha

Access does not store data in .dbf files: everything, tables, forms,
reports, code, system overhead tables, etc. is stored in a single .mdb
file. These can get pretty big.

There is a utility - Tools... Database Utilities... Compact and Repair
Database - which will recover waste space. When you delete anything
(even a large form), Access does not recover the waste space until you
Compact, so this may solve your problem.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public