<div>
Edited text of question<br />

</div>


<div>
<div class="content wysiwyg-content">
I have a database with approximately 15 tables, 20 forms/subforms, 20 queries (of which I have lost track of which one gives what information and which ones are used in forms/reports) and 30+ macros which I have really lost track of. &nbsp;I want to split the database into smaller more manageable databases while maintaining the necessary links and clean up the macros. &nbsp;Is &nbsp;there an easy way to do this other than to just put the tables in one database and all other objects in another? &nbsp;A wizard would be great. 
</div>
</div>


I have a database with approximately 15 tables, 20 forms/subforms, 20 queries (of which I have lost track of which one gives what information and which ones are used in forms/reports) and 30+ macros which I have really lost track of.  I want to split the database into smaller more manageable databases while maintaining the necessary links and clean up the macros.  Is  there an easy way to do this other than to just put the tables in one database and all other objects in another?  A wizard would be great. 

Oversized Database

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.