Wortz, Charles
CWortz at tea.state.tx.us
Fri May 9 13:45:23 CDT 2003
Bobby, Is there anything in common about these 9 queries? Such as do they all have a table in common? If you can determine what they all have in common, then you can narrow down your search for the problem. Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us -----Original Message----- From: Bobby Heid [mailto:bheid at appdevgrp.com] Sent: Friday 2003 May 09 13:41 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