Results 1 to 4 of 4

Thread: Creating Access 97 DB using ADOX

  1. Mar 21st, 2002, 05:12 AM #1
    AuldNick
    AuldNick is offline

    Thread Starter
    Junior Member
    Join Date
    Jan 2002
    Location
    Kesgrave UK
    Posts
    28

    Creating Access 97 DB using ADOX

    I'm trying to get my application to create a new Access DB using ADOX. It seems to be creating the file, but whenever I try to access it manually it gives me the error message 'Unrecognized Database Form 'D:\NewDB.mdb'.

    Set cat = new Adox.catalog

    cat.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\mynew.mdb"

    and then try to create some tables, it gives the same error message wether I try to create tables or not.

    Anybody got any ideas about what I'm doing wrong.

    Cheers.
    Last edited by AuldNick; Mar 21st, 2002 at 05:16 AM.
    Reply With Quote Reply With Quote
  2. Mar 21st, 2002, 05:28 AM #2
    PilgrimPete
    PilgrimPete is offline
    Frenzied Member PilgrimPete's Avatar
    Join Date
    Feb 2002
    Posts
    1,313
    Bit of a guess, but try using Jet 3.51 instead of 4?
    Reply With Quote Reply With Quote
  3. Mar 21st, 2002, 05:38 AM #3
    AuldNick
    AuldNick is offline

    Thread Starter
    Junior Member
    Join Date
    Jan 2002
    Location
    Kesgrave UK
    Posts
    28

    Cheer

    yep that works, cheers Pete
    Reply With Quote Reply With Quote
  4. Mar 21st, 2002, 07:57 AM #4
    oh1mie
    oh1mie is offline
    Frenzied Member oh1mie's Avatar
    Join Date
    Sep 2001
    Location
    Finland
    Posts
    1,043
    You can use 4.0, if you type Enginetype to 4.
    Type 5 is Access 2000 format

    VB Code:
    1. cat.Create "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=D:\MyDatabase.mdb"  _

    2.         & ";Jet OLEDB:Engine Type=4"
    oh1mie/Vic

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width