[AccessD] Alter table

Hi John,

I couldn't get it to work either.
My guess is that DDL must only work on the currentdb.

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com

----- Original Message ----- 
From: "jwcolby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Tuesday, February 26, 2008 11:58 AM
Subject: [AccessD] Alter table


> Is it possible to use the "IN databasename" syntax in an ALTER TABLE SQL
> statement in Access?
>
> I have written code to dynamically alter a table (add a field of a given
> type) in an Access database table.  I wanted to do that so that I could 
> have
> my code "slip in" new fields in the brief periods that a table is not in
> use, rather than have to wait until the evening to get the table into the
> table.  It seems to work if executed directly in the BE itself but I get a
> SQL syntax error if I try to use the "IN DatabaseName" stuff from another
> FE.
>
> 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