RE: [AccessDevelopers] how to add fields in the another db?

[Tom Oakes]

Here's how I might do this: 

 
'***** code start *****'
 
    Dim db As DAO.Database
 
    Set db = 
DBEngine.OpenDatabase("C:\MyDatabase.mdb")
    db.Execute "ALTER TABLE tblSomeTable ADD COLUMN 
SalespersonID LONG"
 
'***** code end *****'
 

Tom Oakes Personal PC Consultants, Inc. [EMAIL PROTECTED] 503.230.0911 (O) 402.968.6946 (C) 713.583.7091 (F) 



From: AccessDevelopers@yahoogroups.com 
[mailto:[EMAIL PROTECTED] On Behalf Of verly 
yuliSent: Thursday, June 30, 2005 6:06 PMTo: 
AccessDevelopers@yahoogroups.comSubject: [AccessDevelopers] how to 
add fields in the another db?
hi all..lanyone could help me?i want to add a field in 
the other dbthank you very muchregardsverly 
yuli            
____________________________________________________ Yahoo! Sports 
Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.comPlease 
zip all files prior to uploading to Files section. 



Please zip all files prior to uploading to Files section.



  
  





  
  
  YAHOO! GROUPS LINKS



   Visit your group "AccessDevelopers" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.