Can splitting .MDB files into segments help with stability?

Posted by Craig Johnston on Stack Overflow See other posts from Stack Overflow or by Craig Johnston
Published on 2010-05-07T06:59:39Z Indexed on 2010/05/07 7:28 UTC
Read the original article Hit count: 245

Filed under:

ms-access

|

splitting

|

database-design

Is this a realistic solution to the problems associated with larger .mdb files:

split the large .mdb file into smaller .mdb files
have one 'central' .mdb containing links to the tables in the smaller .mdb files

How easy would it be to make this change to an .mdb backed VB application?

Could the changes to the database be done so that there are no changes required to the front-end application?

© Stack Overflow or respective owner

Related posts about ms-access

SQLAuthority News – MS Access Database is the Way to Go – April 1st Humor

as seen on SQL Authority - Search for 'SQL Authority'
First of all, today is April 1- April Fool’s Day, so I have written this post for some light entertainment. My friend has just sent me an email about why a person should go for Access Database. For a short background, I used to be an MS Access user once (I will not call myself MS Access DBA), and… >>> More
LINKED TABLES BETWEEN MS ACCESS 2003 AND MS ACCESS 2007-WRITE PERMISSIONS DENIED

as seen on Super User - Search for 'Super User'
We are in the process of switching over to ACCESS 2007. We have numerous data tables in ACCESS 2003 files. In one case, the user has 2007 on his PC and opend the front end in 2007. No problems. When the the user is done, he clicks a button that executes a macro full of update queries. The macro… >>> More
Working with Compressed (zipped) folders in MS Access

as seen on Internet.com - Search for 'Internet.com'
Doug Steele presents a simple technique to add zip files from within your application. >>> More
Extending the InputBox function for MS Access Forms

as seen on Internet.com - Search for 'Internet.com'
While it's not possible to change the behavior of the InputBox function, this article illustrates how to create your own Access form that includes a text box with its InputMask property set to Password, and then use that form instead of the one generated by the VBA InputBox function. >>> More
Uses for Cartesian Products in MS Access

as seen on Internet.com - Search for 'Internet.com'
Less well known than inner and outer joins is the Cartesian product, which produces every possible combination of records between the two tables. Doug Steele offers four examples to demonstrate some legitimate uses for Cartesian products. >>> More

Related posts about splitting

Splitting assemblies - finding the balance (avoiding overkill)

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm writing a wide component infrastructure, to be used in my projects. Since not all projects will require every component created, I've been thinking of splitting the component into discrete assemblies, so that every application developed will only be deployed with the required assemblies. I assume… >>> More
Using Entity Framework Entity splitting customisations in an ASP.Net application

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I have been teaching in the past few weeks many people on how to use Entity Framework. I have decided to provide some of the samples I am using in my classes. First let’s try to define what EF is and why it is going to help us to create easily data-centric applications.Entity Framework is an object-relational… >>> More
Using Entity Framework Table splitting customisations in an ASP.Net application

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I have been teaching in the past few weeks many people on how to use Entity Framework. I have decided to provide some of the samples I am using in my classes. First let’s try to define what EF is and why it is going to help us to create easily data-centric applications.Entity Framework is an object-relational… >>> More
html table with slash splitting the leftup cell

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I wonder how to write in html a table with slash splitting the leftup cell? i.e., for the leftup cell in the table, there is a diagonal line splitting it into two parts, with some texts on either sides. Thanks and regards! >>> More
XSLT: Splitting none continues Elements/Grouping continues Elements

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi! Need some help with this problem in implementing with Xslt, I had already implemented a java code of this one using sax parser but it is a troublesome due to customer request to change something... so we are doing it now using an XSLT with don't need to be compiled and deployed to a web server… >>> More