You asking the wrong question!. The question is not can you have the files
separate. The question you ask is can you use source code control with
ms-access, and yes, we been able to do this...I think going back many
versions all the way to access 97.
So, you don't mention what version of ms-access, but you can most certainly
use VSS (visual source safe) with ms-access. It will thus will allow you to
check in/out forms, reports, code modules and even sql "queries". (heck, you
can't even check in/out your queries when using sql server...so, this very
Here is some info:
Access 2003 Source Code Contorl
For 2007 you simply have to install the developer extensios, and you then
also be able to sue source code ocnotrl...
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada