Run-time error '3035'; System resource exceeded

[cmfog]

I am currently working on a form and I have a list box in my form where I select components and then send the selected ones to a report. I started off just choosing around 3 components and it was working just fine. Then I decided to select all and I tried sending the components to a report but I received the "Run-time error '3035'. I have been doing research I why I did this but I am not getting anywhere

 

[vbaInet]

Can we see the code you run before this error occurs.

 

[cmfog]

From what I have read I think I should increase the MaxLocksPerFile Registry. I have been looking at my VBA code but I am not sure where to place this code:

DAO.DBEngine.SetOption dbMaxLocksPerFile, 1000000

 

[cmfog]

The error wont stop occurring. Every time I try to send any number of components to my report it gives me the '3035' error

 

[vbaInet]

Can we see the code you run before this error occurs.

You've obviously missed it! Just helping you bring it to view.