[AccessD] SourceSafe and Access97 - again.

What do you mean by "always empty"?  You mean they don't get created in
the database or they don't work properly or what?    You might try
deleting those queries from the SS project entirely or at least renaming
them.  Then create a new database from source safe and add the queries
back as new objects, creating them from scratch.  If you delete the old
ones instead of renaming, then don't allow the project to recover the
old version, make it accept the new one.  See if that makes a
difference.   

Occasionally, a SS project becomes corrupt and the only thing you can do
is create a new project from a working version of the application that
is outside of source safe.  Unfortunately, you lose your history that
way, but that's better than the alternatives.

Charlotte Foust

-----Original Message-----
From: Bobby Heid [mailto:bheid at appdevgrp.com] 
Sent: Friday, May 09, 2003 10:41 AM
To: 'accessd at databaseadvisors.com'
Subject: [AccessD] SourceSafe and Access97 - again.


Hi all,

I posted on this a while back and got a few answers.  I followed the
suggestions about building from SS instead of "get latest."  But I am
still having problems.

Basically, I have this FE in SS.  When I do a "create database from
SourceSafe project", there are these 9 queries (out of several hundred)
that always are empty.  Get latest does not bring the data down.
Basically, I have resorted to backing up the queries in another DB
before doing a create database from SS.  I then have to manually cut and
paste the SQL from the queries between the 2 databases.  A royal PIA!

Anyone have any suggestions as to why this may be happening?  It is the
same set of queries every time.  Any suggestions on how to fix this
issue?

Thanks,
Bobby
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com