Results 1 to 5 of 5

Thread: VBA 'only one SQL statement allowed' error, when writing from one database to another

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2024
    Posts
    4

    VBA 'only one SQL statement allowed' error, when writing from one database to another

    Hi! I'm using VBA 7 with MS Word to change field values in a SQLite database. I need to read every record in a table in one database and write it to another table in another database. When I'm trying to get the second record set I get the error: 'only one SQL statement allowed'. I attached the code.
    I'd appreciate any help.
    Attached Files Attached Files

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