Results 1 to 5 of 5

Thread: TableDefs.Append errors out *RESOLVED*

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2001
    Location
    San Jose, Ca. - USA
    Posts
    302

    TableDefs.Append errors out *RESOLVED*

    i can use

    daoOutputDatabase.TableDefs.Append newTable

    on a database I create with:

    Set daoOutputDatabase = daoDbengine.Workspace.(0).CreateDatabase(strOutputPath, dbLangGeneral, dbVersion30)

    but not with :

    Set daoOutputDatabase = daoDbengine.Workspaces(0).CreateDatabase(strOutputPath, dbLangGeneral, dbVersion20)

    here it just errors out with runtime error #3649:

    "The language-specific code page was not specified or could not be found."

    is there something about appending tables to an access 2.0 database I should know.
    Last edited by frigginjerk; Mar 8th, 2002 at 08:50 PM.

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333
    Are you trying to do this from VB6???

  3. #3

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2001
    Location
    San Jose, Ca. - USA
    Posts
    302

    Yes, I'm using VB6.0

    Yes, I'm using VB6.0

    I'm trying to aquaint myself with more DAO objects.

  4. #4

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2001
    Location
    San Jose, Ca. - USA
    Posts
    302

    Why did you ask?

    Hack,

    Why did you ask if I was using VB, can this not be done to a Access 2.0 database in VB.

  5. #5

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2001
    Location
    San Jose, Ca. - USA
    Posts
    302

    Resolution

    I found my problem.

    I was using a reference to DAO 3.6, I guess it does not support adding fields to a tabledef in Access 2.0

    Instead I have to use DAO 3.51, except this does not support creation of Access 2000 database, etc.

    I just wanted to put this here in case anyone was curious.

Posting Permissions

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



Click Here to Expand Forum to Full Width