I have been having a few problems in transferring data from one DBC to another if both DBCs have the same name. (See my earlier posting this thread)

The problem is if they both have the same name then referencing them is difficult.

I am wondering if maybe I should change over to naming my DBCs in a different way.

For example

MYDBC_Dev && for my developmet DBC
MYDBC_Test && for the test DBC the customers get to play with
MYDBC_Live && the live DBC

This would also make me feel less nervous about accidents with the customers live data, since I often have to do a lot of extra checking to make sure its my test data I am messing with and not the customers live data.

This would make copying out the development folder to the live area a bit more awkward but if you use UNC paths its awkward anyway becuase you have to check there are no refernces pointing at your development table.

Does anyone have any good reasons for me not to do this?

Or have I just stumbled onto something everyone has been doing for years anyway.