P
PaulB
I have writing a workshop control & scheduling package in Access 2000 that uses attached tables and have written functions and procedures with set DBS = currentdb followed at the end of a procedure or function set DBS = nothin
When I am debugging or enhansing code and swap between VBA & the Database App I get "Run-Time Error 3048" followed by "Cannot open any more databases" Every time I set currentdb I set it to = nothing at the end of the procedure. My understanding is that once you do that that instance is destroyed. So can anyone tell me where I am going wrong here.
Is there a more elegant way to do this than with currentd
Regard
PaulB
When I am debugging or enhansing code and swap between VBA & the Database App I get "Run-Time Error 3048" followed by "Cannot open any more databases" Every time I set currentdb I set it to = nothing at the end of the procedure. My understanding is that once you do that that instance is destroyed. So can anyone tell me where I am going wrong here.
Is there a more elegant way to do this than with currentd
Regard
PaulB