Access Maximum Modules

[davidk1]

Anyone run into the maximum # of Modules in an Access database? We're getting close and I'm wondering what to do about it? The maximum number of modules is 1000 and this includes any form or report containing code.

What could I do if I run into this limit?

Thanks... David

 

[MajP]

You should be able to put the modules into another database and make it a reference.

 

[davidk1]

Excellent... thanks... I forgot I could set a reference to another database.

 

[MajP]

You may want to also explore

http://www.databasedev.co.uk/access-add-ins.html

 

[davidk1]

Thanks again... I'll have a look.