Projdata Folder

[dave]

In the projdata folder for MSDE projects I have 4 files:

projdata.adp
projdata.mdf
project.mdb
schema.mdb

I know that SQL projects do not use the .adp file but does it use the other 2 .mdb's? If not, where is the data manager "structure" stored
?

[Aplant Monkey]

Dave,

yese the SQL project use those files. the most important one is the Schema, this controls just about everything

[dave]

Cool. Sometimes, I get errors opening up data manager. Usually to do with some view that isn't loading it's tables properly. The error below is telling me that those fields are in the schema but do not exist in the tables. NOW - if I get a really wierd one, I will replace the schema and project .mdb folders with that of the master project. It works great for me and everything is usually ok. Does anyone else do this or is there any danger doing it?

[Aplant Monkey]

When I start a project I always make a back up copy of the Schema as well as the project.mdb files, as well as a couple of other ones, when something goes wrong I can then use MY back-up rather than the generic one. The schema file contains lots of stuff to get familiar with. Be carefull making changes to it when people are in the project though. there are different thoughts on this but I like to make a copy to my C: drive and make changes to it there then overwrite the active Schema which will no hurt users already in the project, some people I know make changes to the actual file, but I have heard of crashes resulting from this procedure. Check out the Rebisview table, you will find lots of good stuff in it.

[dave]

good idea with the copy, i will start doing that.
I have created a "master" project that I base all other projects foff of. Whenever a change happens, I usually make it with that project then overwrite all the other projects project/schema folders.

[Aplant Monkey]

That is a good idae Dave. We do that for each Client as they each have some specific needs that are somewhat customized, especially with P&ID. Each client has their own APCUSTDIR so we actually have a base project for each of our clients. But make sure you make a copy of the project specific files like the Schema. One of the more important ones is the access.mdb file. I always make sure I have this one copied in case it corrupts so that I can easily replace it with little down time.