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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul G - 31 Dec 2003 13:21 GMT

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

Reply to this Message

Les - 31 Dec 2003 13:50 GMT

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.

>-----Original Message-----
>I am running Access 97 and I am getting a message that my
[quoted text clipped - 6 lines]
>Paul
>.

Reply to this Message

John Vinson - 31 Dec 2003 17:49 GMT

>I am running Access 97 and I am getting a message that my
>database has reached maximum size. I have about 150,000
[quoted text clipped - 4 lines]
>
>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.

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

Reply to this Message