[AccessD] Whatamess

Been there, tried that (last month).  It doesn't work. 


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 Arthur Fuller
Sent: Thursday, September 06, 2007 3:43 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Whatamess

Visit Trigeminal Software, JC, and grab their un-replicator tool.
http://www.trigeminal.com/utility.asp?1033

Arthur

On 9/6/07, jwcolby <jwcolby at colbyconsulting.com> wrote:
>
> OK, so the "method" provided by access of getting rid of the s_GUID 
> fields created by the replication process is to use make table queries to
"copy"
> the tables.  I did so.  What is NOT mentioned (and I STUPIDLY failed 
> to think about) is that a make table query is pure sql and as such 
> does not copy such things as default values and format properties for 
> the fields in the table.
>
> WHATAMESS!!!
>
> So, does anyone have code already written that will step through a 
> "from/to"
> table pair and set the properties of the fields in the to table to 
> match the from table?
>
> IOW, if a field in the old table had a default value of zero for a 
> number, the field in the new table does not have a default value, so 
> set the default value to 0 in that field of the new table.
>
> 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