Moving reports

[AccessKid]

I have a bloated frontend mdb (165MB and growing) that I want to breakup into smaller mdbs. Has anybody got some code that I can use to do this quickly, say reports in one mdb, forms in another, etc. Are there restrictions that I need to consider, like after the breakup, will I be able to simply reference the other mdbs an call the forms, reports, queries in those mdbs without mentioning the paths and databases in the code? In other words, will the changed locations of the reports, forms, queries affect the existing vba codes in my application that assumes these objects to be in the current mdb?

Thanks for the help.

 

[KevinM]

165mb....Why so big for a front end?

Have you compacted it recently?

 

[AccessKid]

Yes

Compacted them regularly but there are hundreds of reports, queries and forms in this application - order processing, subcon monitoring, invoicing and shipping.

That's the reason why I need to do the breakup via code.

 

[KevinM]

I can't imagine why you would need literally 100s of reports and queries in ONE db.

Sounds like a structure or design problem you have.

 

[AccessKid]

No gain it seems

Well, give it to "the customer is always right" mentality. Our Marketing department always gives in to customers asking that documents sent to them with their orders follow a certain format. Multiply that with hundreds of customers and you can imagine how many reports we have to do for just a single purpose - a DR for example.

But never mind, I got around to discovering how it can be done and I'm through running a code to move the reports to a new mdb. You know how many reports went into that one? I actually counted 152 and the new mdb size just for these reports is .......124mb! Duh!