Sourcesafe - Leaving objects out of SCC

[Jason]

Please can you help me....
I'm using Access2003 and Sourcesafe 2005

If I don't add ALL the MSAccess objects to sourcesafe, I open my access
database and it says:


Quote:
The source code control project contains more than one database name file.
This message has the following cause and solution:
· While the source code control status of the Microsoft Access objects in
the current project was being refreshed, it was found that the project
contains more than one database name file (for example, db.acn).
Use Visual SourceSafe to remove all but one of the database name files.


However there's only one .acn file in the project
Following this, I can't check out objects

It work fine if I add all the objects to sourcesafe, but I can't possibly do
this. I have dynamic queries and temporary queries that I don't want in
sourcesafe. It must be possible to leave them out, otherwise it wouldn't ask
me which objects I would like to add.

Any ideas please?

 

[Paul Shapiro]

I've always started by adding the whole database to SourceSafe. After that I
can create some objects that get added to SourceSafe and some that don't,
without any errors. I've continued development with some objects not added
to SourceSafe and still don't get errors.

For temporary queries, I've sometimes kept one query whose sql I update on
the fly. Doesn't matter if it's in SourceSafe since the content is only
changed dynamically, so I can add that query to SS also. For actual working
with the database I always use a copy that's been Compacted and had source
control removed.