Re: Modify Linked SQL table in Acess via VBA code
- From: "pietlinden@xxxxxxxxxxx" <pietlinden@xxxxxxxxxxx>
- Date: Thu, 10 Jul 2008 21:30:35 -0700 (PDT)
On Jul 10, 2:51 pm, Bob Bonta <BobBo...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
I have a SQL backend database which is accessed through an Access front-end
with tables linked with a DSN-less connection.
I need to modify one of the linked tables via code (I don't have direct
access to the SQL database via Enterprise Mgr, etc). With an Access BE
database, I would enter the following:
Set db = OpenDatabase("Path & Filename")
Set tdf = db.TableDefs(strTableName)
tdf.Fields.Append tdf.CreateField(strNewFieldName, dbText,
intFieldSize)
However, since I can't modify a linked table to a SQL database with the
above method, I am looking for a similiar snippet which will allow me to
directly modify the SQL table, then I could refresh the link to update the
view to the table.
I'm speculating that I can directly access the SQL table utilizing the same
connection string definition as when I link the table to modify the table on
SQL.
Is this possible? What would be the syntax for that operation?
--
~ Bob Bonta ~
Create an ADO connection to the SQL database, log into the connection
with an account with the proper rights, and then execute a SQL
statement to modify the table. Allen Browne has a bunch of examples
on his website.
www.allenbrowne.com
.
- Prev by Date: Re: Generate a Call Log numer
- Next by Date: Re: Need help processing text file.
- Previous by thread: Generate a Call Log numer
- Next by thread: Re: Modify Linked SQL table in Acess via VBA code
- Index(es):
Relevant Pages
|
Loading
