Database has reached Maximum Size---Help!!!

[Paul G]

I am running Access 97 and I am getting a message that my
database has reached maximum size. I have about 150,000
records with 20 fields each.

Is there anything I can do, or have I reached the
proverbial end of the Internet?????

Paul

 

[Les]

Just a couple suggestions. Compact the database. You can
also try creating a database that just contains your
table. Link the table from that mdb to your current mdb.
And remove the table in your current mdb.

 

[John Vinson]

I am running Access 97 and I am getting a message that my
database has reached maximum size. I have about 150,000
records with 20 fields each.

Is there anything I can do, or have I reached the
proverbial end of the Internet?????

Paul

Tools... Database Utilities... Compact should recover the waste space
left after deleting records. If that doesn't work try creating a new,
empty database and use File... Get External Data... Import to import
all the objects from the big database.

One caveat: Access is HORRIBLY inefficient at storing graphical image
data. If you're storing pictures in this database, don't: most folks
will instead store the images externally in (say) .jpg files, and just
store a path and filename in a simple Text field in the database.
Search for "Image" on the Access Web (http://www.mvps.org/access) for
samples of how to do this.