[AccessD] Alter table

I am going to try opening the BE and getting a DAO db pointer to that db,
then using that DB pointer to execute the SQL. 


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 Michael R Mattys
Sent: Tuesday, February 26, 2008 12:31 PM
To: Access Developers discussion and problem solving
Subject: Re: [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 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com