[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 206
  • Last Modified:

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.
0
cindybr
Asked:
cindybr
1 Solution
 
cindybrAuthor Commented:
Edited text of question
0
 
johngaltCommented:
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

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now