Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    88

    Unanswered: VB Module Transferdatabase

    I'm trying to import data from a table in one access database into another on a recurring basis.

    I invoke the transferdatabase command and when I run it I get the following message if I have "access" as the database type:

    "the access database type isn't an installed database type or doesn't support the operation you chose"

    If I leave the database type blank I get:

    "The type isn't an installed database type or it doesn't support the operation you chose"

    The database that I am importing into is Access 2000 and I'm not sure what version the source database is.

    I have MS Access 10 object library installed

    Does anyone have any ideas on why this isn't working?

  2. #2
    Join Date
    Sep 2003
    Posts
    1
    Try using "Microsoft Access" as the database type instead of "access"

Posting Permissions

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