jwcolby
jwcolby at colbyconsulting.com
Fri Aug 24 12:07:11 CDT 2007
OK, then does anyone have prewritten code for logging / deleting / recreating relationships between tables? This is one area I have never delved into. 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 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