Post reply

Cursor and concurrency change on sql driver

  • January 13, 2003 at 11:18 pm

    #101351

    I upsized from access to sql server. Why are all of the exported tables in SqlServer renamed with database name? ex:

    products is now db1.products

    categories is now db1.categories etc..

    Thanks for help..btw, yes, I am lame newbie

    Dave

    yeh

    Edited by - superdave on 01/13/2003 11:19:55 PM


    yeh

  • January 16, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • January 16, 2003 at 9:30 pm

    #446600

    It has been that way as long as I can remember (version 2.0, late 80's). I created a code snippet to rename tables by stripping the first few characters off the table names, many years ago, and if I can find it, I'll post it for you. It is standard behavior. Rename them and continue on. If you want to write the code yourself, it's simple, itterate through the tables collection and change the name property.

    Oh, and there's no such thing as a lame newbie, they are potential guru's in the making....(course, I been in the making for 17 years, and I'm still wondering when I'll get there.....)

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

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