Extend MDB File

  • Thread starter Thread starter March
  • Start date Start date
M

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
 
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
 
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
 
March said:
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.
Click to expand...

Now that you split, what is the size of the FE after you do a compact and
repair on it?
 
This really helpful. The FE file reduced its size after I did a compact and
repair on it.


Thank you so much
 
Back
Top