[AccessD] Deleting system fields

jwcolby jwcolby at colbyconsulting.com
Fri Aug 24 11:29:54 CDT 2007


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 




More information about the AccessD mailing list