I have an MS Access 2000 front end, am utilizing SQL Server 7 for the back 

end database, and am in the process of placing the .MDB under VSS.  I have 

successfully placed the .MDB's under source code control, however, I have 

2 ODBC settings for the databases, one is the Production one, let's use 

EEEEE for the name of the database, one is in test and the name is 

TestEEEEE.  When I Create Database from Source Safe Project... and create 

the .MDB ok it has the production ODBC settings.  I want to change the one 

in my working directory to point to the test database, TestEEEEE.  I have 

to check out all the tables and go through the Linked Table Manager in 

Database Utilities, which shouldn't be a problem, however, if one of the 

other developers gets the .MDB and wants to do some testing, and goes 

through what I just mentioned, he/she cannot check out the tables, as I 

have them already checked out.  I do not want to check them in after I 

make my changes, as I do not want the production db in VSS to point to the 

TestEEEEE database.  I know this is kind of complicated, but if any one 

has any ideas on how to handle this, it would be greatly appreciated to 

give me an idea or two as to remidy this situation.  Thoght about not 

including the tables, as there are ODBC linked tables and Access tables, 

but, then you cannot Create Database from Source Safe Project because the 

Data and Misc. objects were not checked in.