Oversized Database

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.
cindybrAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
johngaltConnect With a Mentor Commented:
Use the Tools, Add-Ins, Database Splitter menu option to split your database.  I've never used it, but it is supposed to split a database into two files: one that contains the tables and one that contains the queries, forms, reports, macros, and modules.  It also is supposed to handle all the links between the two new databases.

As far as documenting your application, consider Total Access Analyzer from FMS (www.fmsinc.com).  It offers comprehensive documentation of your database -- honestly, more than you could ever want.  It will show you where and how your code, macros, forms, tables, fields, etc. are used within your database.
0
 
cindybrAuthor Commented:
Edited text of question
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.