Size of acess dbf files

[Guest]

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

Fortune Iroha

 

[Marc]

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

 

[John Vinson]

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.