News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • APPEND QUERY

    Viewing 1 reply thread
    • Author
      Posts
      • #351451 Reply
        WSCary
        AskWoody Lounger

        Im trying to append from one Access DB to another DB. If the target DB has a Pass word set the query Im trying to create wont work. When I get it all done and run it, it says No database in in clause or sum such. If I unset the PW on the target DB and then create the query it will work.
        If I then set a pass word in the target DB, when I run the query it only asks for the date parameter I have set. It will not ask for the PW. However if I open the query in design view, it asks for the password. It opens in design view and if I try to run it from there it will not ask for the PW. This is the query that works without the PW in target DB.
        INSERT INTO CoilIn ( ItemNo, Weight, Rec, Mill, [PO#], LocNo ) IN ‘Amerimax1.mdb’
        SELECT tblMatics.PartNo, tblMatics.Weight, tblMatics.Date, tblMatics.Anaheim, tblMatics.PoNumber, IIf([Anaheim]=”A”,”A” & [Lot#],[Lot#]) AS Expr1
        FROM tblMatics
        WHERE (((tblMatics.Date)=[typr Date]));
        Can anybody tell me where to put a PW in it ?
        Access just wont create a working append query if I have a PW set. Any help will be appreciated.
        For example, please use password “cary”
        Thanks Cary

      • #508507 Reply
        WSCary
        AskWoody Lounger

        Access 97

        • #508661 Reply
          WSCary
          AskWoody Lounger

          Well, looks like Im not going to get an answer to this one. But thanks anyway people. I have gotten a lot of good advice before from this place. Guess Ill just have to hit the books again.
          Thanks Cary

    Viewing 1 reply thread

    Please follow the -Lounge Rules- no personal attacks, no swearing, and politics/religion are relegated to the Rants forum.

    Reply To: APPEND QUERY

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.