[AccessD] remotely alter a table

Susan,

Like this...

   Dim dbsRemote As DAO.Database
   Set dbsRemote = OpenDatabase(RemotDbPathName)
   dbsRemote.Execute "ALTER TABLE ... yada ...", dbFailOnError
   dbsBE.Close

Regards
Steve


--------------------------------------------------
From: "Susan Harkins" <ssharkins at gmail.com>
Sent: Saturday, September 19, 2009 4:49 AM
To: <AccessD at databaseadvisors.com>
Subject: [AccessD] remotely alter a table

> Can you run ALTER TABLE against a table in a remote database and if so, 
> how
> do you identify that database?
>
> ALTER TABLE completepath&tablename
>
>
>
> Anyone know if that will work?
>