I need to find the setting in Access 2007 (and 2010) that would allow the user the ability to open 2 different mdb files simultaneously. Currently, if there is an mdb file open and I try to open another one; the originally opened file closes.
I have looked in the options and canoot find a setting to make this possible. I have also looked here and on the googles and could not find a solution (although perhaps it might be the keywords I am using). Please let me know if you need more details, here are some: the files are local on the machine and this happens whether I open from the file menu or double click the icon for each.
Thanks in advance for your help!