Hi, Alan.

One could use VB Script, which is free and fairly simple if one knows how to
write queries.  For example, the following code saved as the file
AddFKeyToTable.vbs would allow one to double-click the script file and
thereby add a foreign key to the tblProducts table in the C:\Work\MyDB.mdb
database file:

   Dim cnxn
   Dim sDBPath

   sDBPath = "C:\Work\MyDB.mdb"

   Set cnxn = CreateObject("ADODB.Connection")
   cnxn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
       sDBPath & ";Persist Security Info=False"
   cnxn.Execute "ALTER TABLE tblProducts " & _
       "ADD CONSTRAINT tblSupplierstblProducts_FK " & _
       "FOREIGN KEY (SupplierID) REFERENCES tblSuppliers SupID;"
   cnxn.Close

   Set cnxn = Nothing

If an index or an extra column was needed, then the SQL statement of the
query could easily be changed and the rest of the VB Script would remain the
same.  The users don't have to be out of the database, but the script
requires a table lock, so no users can be using the table when it's being
altered by the script.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.