[AccessD] remotely alter a table

Heenan, Lambert Lambert.Heenan at chartisinsurance.com
Fri Sep 18 12:16:46 CDT 2009


Depends how remote "remote" is. If you can see the MDB file on your network then you can just do these steps....

1/ Open the database
Const BEPATH = "\\SomeServer\SomePath\SomeFile.mdb"
    Set db = OpenDatabase(BEPATH)

2/ Create a querydef object in the database
Const ATER_TABLE_SQL = "alter table SomeTable add  column nsngAdvanceRate single;"
    Set qd = db.CreateQueryDef("MyTableUpdate", PolicyPipeline_Add_Columns)
    qd.SQL = PolicyPipeline_Add_Columns
    qd.Close

3/ Execute the query
    db.Execute qd.Name 

4/ Optional - delete the query def object
   DoCmd.DeleteObject acQuery, "MyTableUpdate"

HTH

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Friday, September 18, 2009 12:50 PM
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?



Susan H.

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




More information about the AccessD mailing list