Size of acess dbf files

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Fortune said:
I am currently creating a small ms-access data base, about 10 tables each
Click to expand...
with about 10 records, these have
to link to forms, which have command buttons and macros, any idea how
Click to expand...
large this file should get? as my
floppy seems to be too small to store it !!

Fortune Iroha
Click to expand...
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
 
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
Click to expand...

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.
 
Back
Top