Extend MDB File

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
 
R

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
 
M

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
 
A

Albert D. Kallal

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?
 
M

March

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


Thank you so much
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 and/or 2007 copy in objects from another mdb 1
mdb 2 giga 8
Copy a table in an external database 1
how to open an mdb file has a database password form another mdb 1
Transfer data from any mdb file to sql server? 1
MDB and connected users/computers 5
Prevent odbc connection to the backend mdb 5
Access 2002 Lock File Location 1

Top