I would have to agree with Tamor and it sounds like you need to thump your 'predecessor' on the nose for not setting up a development environment. If he needs data from production then he should download that data into his development tables. Bad practice on his part (no practice cookies!).

If he cannot understand the whys and wherefores of setting up his development environment correctly, then perhaps he shouldn't be allowed back on the project.

>My predecessor thought the DBC had to have all tables connected to it, but when he went from development mode to actually using the database and the files associated with it, he ran into problems, which I am running into.
>
>The DBC is on our network drive and if I want to be in development mode and the DBC is the one from the network, someone else may be using it and for some reason (EXCLUSIVE?) I cannot then access it while in DEV mode, or the other person can't get in if I am in it.
>
>I am thinking about disconnecting all tables and making them free tables, because none of the tables are using any of the DBC's capabilities such as long file names, code within the DBC, etc. I've gotten to where I find the DBC's to be a real bother unless I use them to connect to other databases such as MS access or SQL Server.
>
>In this case, for one project, I am NOT concerned about connecting to foreign tables or databases, so the problem now is:
>
>How do we test some changes in code without affecting the network tables? We have a DBC that is in the Project and when you look at it, some of its tables are on the network and some aren't; this was set up by my predecessor and he is back trying to test some new changes to our timekeepign system which he made yesterday, without affecting the network tables; we want to test only the data on his local PC, C:\ drive. So, even if we put the tables on the local PC, because the DBC is in the project, won't it point to the network Tables?
>
>I must first apologize for not being able to lay this out in a shorter write-up; it is difficult for me in some cases to properly lay out the real problem.