Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Posts
    1

    Unanswered: prog.ly supply path to make-table query

    Is there a way to programmatically supply a path to a make-table query that will put the new table in an external access database?
    also, would need to supply the database password for the external database.

    thanks,
    Buddy

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi

    My take on this would be to automate the remote db (supplying the password when you reference it) and use a make table query in your automated database. I would just execute it as a DAO.Database execute. SQL something like:
    Code:
    SELECT * INTO MyewTable
    FROM Table1 IN 'C:\Remotedb.mdb'
    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    BTW - Welcome to the forum
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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