Heenan, Lambert
Lambert.Heenan at AIG.com
Fri Aug 24 12:21:53 CDT 2007
But it's still a replica your looking at (by the sound of it). In which case you can 'recover the design master', which simply means you're telling Access 'this here replica IS the design master'. Lambert -----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