[AccessD] remotely alter a table

Okay -- it's easier than I thought. I was trying to work a SQL IN into that 
ALTER TABLE and maybe you can, but I just couldn't make it make sense. Thank 
you!

Susan H.


> 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?
>>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com