[RESOLVED] is there a way to create a new field in an existing table that has password protecte?

[SamOscarBrown]

you were so close with:

Dim StrSql As String 
         StrSql = "Update Alter table [BackArc] Add [Remarks] [Memo]"          
CN.Execute StrSql

Now, look at this EXAMPLE (IN THE LINK I SHOWED YOU IN #11):

StrSql = "ALTER TABLE Customers  ADD COLUMN CustName TEXT 25

can you take it from here? (Wish you had studied that tutorial!)