Post reply

adding a new table in sql 2005

  • October 20, 2008 at 8:59 am

    #125602

    Dear All,

    I have an SQL 2005 database and I have added a new table. I have an ms access 2003 database and I could link to the sql tables. However, I could not see the new table.

    I refreshed the link manager and retested the ODBC and both refresh ok.

    I used script to create the table.

    Any idea as to why I cannot see the new table? What do I need to do??

    Many thanks.

    Regard,

    Carmel

  • October 20, 2008 at 9:05 am

    #887174

    DEAR ALL,

    APOLOGIES, I RE-LINKED THE TABLE AND IT IS NOW WORKING.

    REGARDS,

    CARMEL

  • October 20, 2008 at 10:10 am

    #887212

    Thanks for the update and be aware that there are sometimes strange caching things that break for unknown reasons. Relinking would have been my suggestion if I were a little quicker. 🙁

    Glad you figured it out.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply