Database Size

[Access 2003 Newbie]

Hi,

Could anyone tell me how much data (in rows) can be stored
in the new Access 2003? Or maybe what is the maximum
database capacity?

 

[Brendan Reynolds \(MVP\)]

There is no maximum number of rows. There is a maximum database capacity of
2GB. See 'specifications' in the help file for details.

 

[cmeeks]

So somehow my database is now 2.1 gig. It was 1.2 and I
ran a query that kept failing by saying that I was trying
to redo something that hadn't been started yet. Now the
database will not open. Does anyone know how I can get
into it to try to determine what happened to make it so
large and reduce the size so it'll open long enough for me
to delete/split things? Thanks.

 

[John Vinson]

So somehow my database is now 2.1 gig. It was 1.2 and I
ran a query that kept failing by saying that I was trying
to redo something that hadn't been started yet. Now the
database will not open. Does anyone know how I can get
into it to try to determine what happened to make it so
large and reduce the size so it'll open long enough for me
to delete/split things? Thanks.

I HOPE you have a backup. An Access database is limited to 2 GByte.

Try creating a new, empty database. Use File... Get External Data...
Import to import everything from this monster. For safety, I'd suggest
importing by object types - import the tables, compact the database;
import the Queries, compact; import any Macros; import the Forms, open
the VBA editor, and use Debug... Compile <project> from the menu (if
any forms have any VBA code); do the same for Reports and Modules.

Regular compaction is ESSENTIAL maintenance, and even 1.2GByte is
very, very large. Do you have graphics or OLE objects stored in the
tables? If so, consider storing them externally.