Bobby Heid
bheid at appdevgrp.com
Mon May 12 08:52:49 CDT 2003
Update to my last e-mail. I tried deleting the queries from SourceSafe, then imported the queries from a non SS db. When creating the db from SS, I get the same problem. I create copies of the queries in the db when I take it out of SS. SO I can get the queries back, it is just a pain to do each time and I'd like to correct the problem if I could. So along those lines, I am not expecting anyone to put a lot of effort into this issue. I find it strange that no one else here seems to have ever had this problem. Thanks again, Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bobby Heid Sent: Monday, May 12, 2003 7:25 AM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] SourceSafe and Access97 - again. Hi Charlotte, Empty, as when you create a new query. There is nothing in it except for the standard "Select;". We are always putting out point releases for this app as they always want more added. Each time I do a release, I create a new SS project. I have not tried to delete the objects out of SS and re-adding them. I will give that a try. The weird thing is, once I put them back in, I can check them out, modify, and pout them back and all is well. Thanks, Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Friday, May 09, 2003 3:14 PM To: accessd at databaseadvisors.com Subject: RE: [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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/ms-tnef Size: 3555 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030512/9fa5fe95/attachment-0001.bin>