[AccessD] Renaming a field through code

Bill Patten bill_patten at embarqmail.com
Fri Jul 18 12:13:52 CDT 2008


Rocky,

 I have a routine that I got from you back in 2005, "mod_ModifyTablesFEorBE" 
that I believe will do that. I can send it to you if you want.

Copy of your notes:
**********************
Never mind.  Figured it out.  I have the name and path of the linked
database in a global variable already. So:

Set wrk = DBEngine.Workspaces(0)
Set Db = wrk.OpenDatabase(gstrDatabaseName)

Dim strSql As String
strSql = "ALTER TABLE tblPODetail ALTER COLUMN fldPODPartDescription
TEXT(255);"
Db.Execute strSql, dbFailOnError


works.

Rocky

----- Original Message ----- 
From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>

*****************************

Bill








----- Original Message ----- 
From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Friday, July 18, 2008 9:56 AM
Subject: [AccessD] Renaming a field through code


Dear List:

Is is possible to rename a field in a linked table through code?

MTIA





Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/>

www.bchacc.com <http://www.bchacc.com/>






-- 
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