jwcolby
jwcolby at colbyconsulting.com
Fri Aug 24 17:12:13 CDT 2007
Ahhh... I missed that. I did indeed try the first and missed the second. I have used the first one several times in the past, but never knew about the second one. Thanks. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Friday, August 24, 2007 4:42 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Deleting system fields John, The one I provided the link to. He has two utilities on his site in regards to replication. This one: http://trigeminal.com/lang/1033/utility.asp?ItemID=7#7 which is the "Access 2000 Un-replicator" and this one: http://trigeminal.com/lang/1033/utility.asp?ItemID=11#11 which is the "Replication Systems Fields utility" I believe you tried the first, but what you want is the second. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, August 24, 2007 2:11 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Deleting system fields What do you mean when you say "THIS is a utility different...". What utility are you referring to? John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Friday, August 24, 2007 1:46 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Deleting system fields John, I think this a utility different then the one you tried. This one is used to remove the system columns specifically. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, August 24, 2007 1:17 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Deleting system fields There never was a master or replica. The button was pushed by mistake YEARS ago and (apparently) there was no backup because they left it that way. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Friday, August 24, 2007 1:06 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Deleting system fields John, <<I tried running trigeminal's unreplicator but I think they got confused by the unreplicated fields and said it wasn't replicated and didn't do anything.>> Your talking about this? http://trigeminal.com/lang/1033/utility.asp?ItemID=11#11 The only other thing I know you can do is to: 1. Synch all replicas 2. Recover the design master if you don't have it. 3. Then use the unreplicate wizard. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Friday, August 24, 2007 12:35 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Deleting system fields I've never found any but the hard way, John. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, August 24, 2007 9:30 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Deleting system fields I have a database that was apparently "replicated" at some time (the button pressed by mistake), then other tables later added that were not replicated. I tried running trigeminal's unreplicator but I think they got confused by the unreplicated fields and said it wasn't replicated and didn't do anything. I tried to delete just the system field S_GUID but was told I can't because it is a system field and I can't do that. The "suggestion" was to rebuild the table by doing a make table without the S_GUID field. I can certainly do that but I have to also break existing relationships, delete the existing data and then recreate the relationships. Is there ANY method of just deleting the S_GUID field? It is doing no damage but it is taking up space, is confusing, and is simply not needed and I would like to get rid of it. John W. Colby Colby Consulting www.ColbyConsulting.com -- 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 -- 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 -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com