Results 1 to 3 of 3

Thread: Alter Table

  1. #1
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5

    Unanswered: Alter Table

    I am trying to change the filedtype (text) to a number in code

    currentdb.Execute "ALTER TABLE tbldynamicreport ALTER COLUMN text1 Number", dbSeeChanges

    The name of the field is text1
    the table is tbldynamicreport

    I tried DBNumber as well but I keep getting syntax error - any ideas?
    Dale Houston, TX

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    I think you need the actual desired data type, like Integer.
    Paul

  3. #3
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    yes - this fianlly worked
    CurrentDb.Execute "alter table tblOne alter column jobnum integer"
    Dale Houston, TX

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •