Alter Table to change Field Datatype

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am amending a field's datatype using the following:

Set db = CurrentDb()
strSQL = "ALTER TABLE TblUserFieldEmployeeDetails ALTER COLUMN " &
fldName & " " & strFieldType
db.Execute strSQL

The datatype has been changed immediately and successfully when I look at
the table in desgin view, but none of the forms will pick up the new datatype
without completely closing the database and reopening it.

Is there a way to reload/refresh the tables without having to exit the
databse?

Many thanks
 
Back
Top