Extend MDB File

[March]

I would like to know how I can extend my mdb file when I have my current mdb
file reaches 2GB. Please give me suggestion.


Thanks

 

[Roger Carlson]

You can't. The maximum size of an MDB file is 2GB. However, you could put
tables into separate MDB files and link them into a "front-end" database.
There is no limit to the size unless a single table gets to be 2GB.
However, by that time, you should be seriously looking to upgrade to SQL
Server.

BTW, have you tried compacting the database? It may just be "bloated".

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[March]

Roger,

Thank you for your answer. It's helpful.

I come up with another question.

I know in this case if I use SQL Server would be easy. However, I can use
only MS Access for this project.

What I have done now is following below.

Without using database splitter the file contains 994,172Kb. After separated
FE and BE, the FE still has 994,172Kb and BE has 247,616Kb.

My idea is to separate the file into 3 files.(I can see that the file can
break into two systems) one can be a main database that links to the other
two MDB files. Do you think I should do this way to get rid of the big file
size.

Please give me suggestion.


Thanks

 

[Roger Carlson]

Before you do anything else, compact both the front-end and the back-end.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Albert D. Kallal]

Without using database splitter the file contains 994,172Kb. After
separated
FE and BE, the FE still has 994,172Kb and BE has 247,616Kb.

Now that you split, what is the size of the FE after you do a compact and
repair on it?

 

[March]

This really helpful. The FE file reduced its size after I did a compact and
repair on it.


Thank you so much