[AccessD] Deleting system fields

jwcolby jwcolby at colbyconsulting.com
Fri Aug 24 13:11:20 CDT 2007


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




More information about the AccessD mailing list