Converting to accde files
Posted on 2010-08-23
Greetings all ...
A solution I've just received on a different question is (finally!) providing strong encouragement for me to convert my applications to accde/accdb pairs of files. I'm concerned that coding practices I've adopted in the past won't easily support a conversion to an accde environment. At least not without some serious rethinking and quite a bit of recomposition.
To date the structure I've utilized is basic textbook. Two files, one front end and one back end, both mdb or accdb files. Back end file is all tables, front end file is everything else (including an autoexecute macro), with links to all the tables in the back end. Basic beginner textbook.
The most obvious potential conflict I'm envisioning, as I try to convert at least one of these files to a compiled format, is that I have dozens of instances throughout the front end of my apps where queries, based on conditions available at the moment, are created on the fly, executed, and then deleted. Am I right in assuming that those, at least as they're currently structured, won't run in an accde environment?
Let's assume that my rewriting all instances of this 'create/manipulate/delete' coding methodology isn't an option. Is it possible for me, from within the accde file, to direct that these temporary objects be managed on a workspace within another, linked, read/writable accdb file?
I hope I've articulated this little issue clearly. The implications of your responses, regarding the larger general question of 'how to manage multiple linked files', will clearly have a huge bearing on how I view and map out future projects.
I am so grateful for your willingness to lend your expertise to lost souls like me!