Re: Action pass-through with a form variable Access 2003

magickarle wrote:
Peter Doering wrote:
magickarlewrote:
Peter Doering wrote:

You cannot create a *local* table using pass-through (PT). If you need
TblTemp in your local mdb the easiest would be a standard query on the
linked table empl_Lst.

If it's not possible to create a local table, then would it be
possible to append to an access table the output of a pass-through
query?

PT means that all control is handed over to the target Server and it
doesn't know about your local tables, so no, you cannot append either.

As mentioned, the easiest way would be to establish a link to the server
table and perform a local query.

You can use the sample to create the link:

|>   DoCmd.TransferDatabase acLink, "ODBC Database", _
|>    "ODBC;Driver={SQL Server};Server=Instance\YourServer;" & _
|>    "Database=YourDB;UID=USERID;PWD=PWD;", _
|>    acTable, "empl_Lst", "empl_Lst", , True

Actualy I've found a way:
In the GUI, ...

of Access?

... I've create an action query that uses the pass-through
query.
From there, I can run it: It will run the pass-through as pass-through
and will append (or create) a table.

It will append (or create) a table on the server that you have passed the
query through to.

It is not a "direct data dump" from the pass-through but it does the
job.

Good for you.

--
Peter Doering [MVP Access]
.

Relevant Pages

  • Re: Membership database updates
    ... When you open any Query in Design View, click on the toolbar just next to ... black down-arrow where you can change your query to an Append or Update ... If you have any current members in your Import list, ... You mention Update Queries and Append Queries but I can't find how to ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Assign macro on After update event
    ... I don't see why you can't append the current record next scheduled date to ... it then try using an update query to update the dates in the new record. ... "Anna" wrote: ... maybe you can help me with that: all this macro is ...
    (microsoft.public.access.forms)
  • Re: duplicates query help & strategy for update queries with SetWarnings = False
    ... I have many many queries that check for orpaned data (for example, if there's a billing record with no matching custID in the customer table, I'm putting up a form with the unmatched data, and a quick way to update all unmatched to one archive type customer, etc. ... I was surprised to see duplicate entries in some of the static tables for dropdown selections, so I have to solve this one now. ... Once the user has handled all the problems, you enable the final command button at the bottom of the form, which executes an append query to add the data to the real table. ...
    (comp.databases.ms-access)
  • Re: Update table from ODBC
    ... criteria are interpreted differently. ... SQLGetInfo and SQLGetTypeInfo to ask the ODBC driver whether the server ... If you want, post the SQL Strings of your Pass-Through Query, your Append ... Query using the Pass-through and your Append Query using ODBC-linked Table ...
    (microsoft.public.access.queries)
  • Re: Append Query Date Criteria Problem.
    ... Why can't I append some records? ... Choose Parameters on the Query menu. ... Access opens the paramters dialog. ... > End Sub ...
    (microsoft.public.access.queries)