[RESOLVED] Access Database has reached a maximum size

[fkwinna]

Hi every one
Greetings
I have access2000, I have an application by visual basic6 which handle an database file with 42 table , now I got this message ( database has reached a maximum size), so may database file size is (0,99 GB) the application stop , what can I do
Thanks

[si_the_geek]

Thread moved to the 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums)


In the short term, do a Compact & Repair of the database to reduce the size a bit.

In the longer term, either reduce the size by altering your database design (if you have repetition etc), or change to a database system that allows the size you need. The recent versions of SQL Server Express allow 10 GB, and are free (and are better in many ways, but not necessarily any other improvements for your needs).