|
|
|
date: Mon, 15 May 2006 13:01:19 -0500,
group: microsoft.public.access.odbcclientsvr
back
Re: Query to MS SQL Server 2000??
Some types of field can be troublesome with ADP; you should check that by
removing columns until you find the offending one; if there is one, of
course.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Austin" wrote in message
news:e5XztuGeGHA.2416@TK2MSFTNGP03.phx.gbl...
> Yes, I also subsequently thought of that and checked, but I use an auto
> increment PK in SQL Server and it shows up in the Access definition of the
> linked table. All the fields have "deleted" in them, the correct number of
> records are returned. The pass through query works OK. Weird???
>
> Austin
>
>
>
>
> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> wrote in message news:OVfIbOGeGHA.4932@TK2MSFTNGP03.phx.gbl...
>> Maybe a missing primary key.
>>
>> --
>> Sylvain Lafontaine, ing.
>> MVP - Technologies Virtual-PC
>> E-mail: http://cerbermail.com/?QugbLEWINF
>>
>>
>> "Austin" wrote in message
>> news:OqRHRmEeGHA.3388@TK2MSFTNGP05.phx.gbl...
>>> Hi,
>>>
>>> I'm trying to use Acccess to get data fom MS SQL Server. I linked a
>>> table and made a query, but the data appears as "DELETE" every where. I
>>> tried a pass through query to the same table and it seems to work OK????
>>>
>>> Can the SQL and Where be set with VBA for a pass through query?? Any
>>> examples??
>>>
>>> Thanks,
>>>
>>> Austin
>>>
>>
>>
>
>
date: Mon, 15 May 2006 19:14:28 -0400
author: Sylvain Lafontaine sylvain aei ca (fill the blanks, no spam please)
Re: Query to MS SQL Server 2000??
Another possibility would be the presence of a trigger. Did you choose DRI
or Triggers when you made the upsizing?
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Austin" wrote in message
news:e5XztuGeGHA.2416@TK2MSFTNGP03.phx.gbl...
> Yes, I also subsequently thought of that and checked, but I use an auto
> increment PK in SQL Server and it shows up in the Access definition of the
> linked table. All the fields have "deleted" in them, the correct number of
> records are returned. The pass through query works OK. Weird???
>
> Austin
>
>
>
>
> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> wrote in message news:OVfIbOGeGHA.4932@TK2MSFTNGP03.phx.gbl...
>> Maybe a missing primary key.
>>
>> --
>> Sylvain Lafontaine, ing.
>> MVP - Technologies Virtual-PC
>> E-mail: http://cerbermail.com/?QugbLEWINF
>>
>>
>> "Austin" wrote in message
>> news:OqRHRmEeGHA.3388@TK2MSFTNGP05.phx.gbl...
>>> Hi,
>>>
>>> I'm trying to use Acccess to get data fom MS SQL Server. I linked a
>>> table and made a query, but the data appears as "DELETE" every where. I
>>> tried a pass through query to the same table and it seems to work OK????
>>>
>>> Can the SQL and Where be set with VBA for a pass through query?? Any
>>> examples??
>>>
>>> Thanks,
>>>
>>> Austin
>>>
>>
>>
>
>
date: Mon, 15 May 2006 19:15:15 -0400
author: Sylvain Lafontaine sylvain aei ca (fill the blanks, no spam please)
Re: Query to MS SQL Server 2000??
No, I pumped the data from an AS400 to SQL Server using a Delphi program. It
ran fast and I created a few additional output fields. The data shows up
correctly in a Delphi Grid component using either ADO or dbXpress
connections. Weird that a linked table and our a query to the linked table
shows garbage while the pass through query shows all OK.
I think it must be something in the ODBC link, but the pass through uses the
same one??
Austin
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:OjuzyVHeGHA.4128@TK2MSFTNGP05.phx.gbl...
> Another possibility would be the presence of a trigger. Did you choose
> DRI or Triggers when you made the upsizing?
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: http://cerbermail.com/?QugbLEWINF
>
>
> "Austin" wrote in message
> news:e5XztuGeGHA.2416@TK2MSFTNGP03.phx.gbl...
>> Yes, I also subsequently thought of that and checked, but I use an auto
>> increment PK in SQL Server and it shows up in the Access definition of
>> the linked table. All the fields have "deleted" in them, the correct
>> number of records are returned. The pass through query works OK. Weird???
>>
>> Austin
>>
>>
>>
>>
>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
>> wrote in message news:OVfIbOGeGHA.4932@TK2MSFTNGP03.phx.gbl...
>>> Maybe a missing primary key.
>>>
>>> --
>>> Sylvain Lafontaine, ing.
>>> MVP - Technologies Virtual-PC
>>> E-mail: http://cerbermail.com/?QugbLEWINF
>>>
>>>
>>> "Austin" wrote in message
>>> news:OqRHRmEeGHA.3388@TK2MSFTNGP05.phx.gbl...
>>>> Hi,
>>>>
>>>> I'm trying to use Acccess to get data fom MS SQL Server. I linked a
>>>> table and made a query, but the data appears as "DELETE" every where. I
>>>> tried a pass through query to the same table and it seems to work
>>>> OK????
>>>>
>>>> Can the SQL and Where be set with VBA for a pass through query?? Any
>>>> examples??
>>>>
>>>> Thanks,
>>>>
>>>> Austin
>>>>
>>>
>>>
>>
>>
>
>
date: Mon, 15 May 2006 18:36:11 -0500
author: Austin
Re: Query to MS SQL Server 2000??
The pass-through doesn't use the linked table at all and display the
resultset as created and returned by the SQL-Server.
The problem may come from the additional fields that you have created on the
table: did you take the precaution of refreshing the link after you created
them?
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Austin" wrote in message
news:uxspahHeGHA.3948@TK2MSFTNGP03.phx.gbl...
> No, I pumped the data from an AS400 to SQL Server using a Delphi program.
> It ran fast and I created a few additional output fields. The data shows
> up correctly in a Delphi Grid component using either ADO or dbXpress
> connections. Weird that a linked table and our a query to the linked table
> shows garbage while the pass through query shows all OK.
>
> I think it must be something in the ODBC link, but the pass through uses
> the same one??
>
> Austin
>
>
>
> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> wrote in message news:OjuzyVHeGHA.4128@TK2MSFTNGP05.phx.gbl...
>> Another possibility would be the presence of a trigger. Did you choose
>> DRI or Triggers when you made the upsizing?
>>
>> --
>> Sylvain Lafontaine, ing.
>> MVP - Technologies Virtual-PC
>> E-mail: http://cerbermail.com/?QugbLEWINF
>>
>>
>> "Austin" wrote in message
>> news:e5XztuGeGHA.2416@TK2MSFTNGP03.phx.gbl...
>>> Yes, I also subsequently thought of that and checked, but I use an auto
>>> increment PK in SQL Server and it shows up in the Access definition of
>>> the linked table. All the fields have "deleted" in them, the correct
>>> number of records are returned. The pass through query works OK.
>>> Weird???
>>>
>>> Austin
>>>
>>>
>>>
>>>
>>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
>>> wrote in message news:OVfIbOGeGHA.4932@TK2MSFTNGP03.phx.gbl...
>>>> Maybe a missing primary key.
>>>>
>>>> --
>>>> Sylvain Lafontaine, ing.
>>>> MVP - Technologies Virtual-PC
>>>> E-mail: http://cerbermail.com/?QugbLEWINF
>>>>
>>>>
>>>> "Austin" wrote in message
>>>> news:OqRHRmEeGHA.3388@TK2MSFTNGP05.phx.gbl...
>>>>> Hi,
>>>>>
>>>>> I'm trying to use Acccess to get data fom MS SQL Server. I linked a
>>>>> table and made a query, but the data appears as "DELETE" every where.
>>>>> I tried a pass through query to the same table and it seems to work
>>>>> OK????
>>>>>
>>>>> Can the SQL and Where be set with VBA for a pass through query?? Any
>>>>> examples??
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Austin
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
date: Tue, 16 May 2006 00:48:08 -0400
author: Sylvain Lafontaine sylvain aei ca (fill the blanks, no spam please)
Re: Query to MS SQL Server 2000??
Sylvain,
The ODBC Connection, and the Access link were just created on the table. No
changes to the underlying SQL Server table. When creating the pass through
query, I thought I used the same ODBC connection.
Austin
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:uIeU0PKeGHA.3996@TK2MSFTNGP04.phx.gbl...
> The pass-through doesn't use the linked table at all and display the
> resultset as created and returned by the SQL-Server.
>
> The problem may come from the additional fields that you have created on
> the table: did you take the precaution of refreshing the link after you
> created them?
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: http://cerbermail.com/?QugbLEWINF
>
>
> "Austin" wrote in message
> news:uxspahHeGHA.3948@TK2MSFTNGP03.phx.gbl...
>> No, I pumped the data from an AS400 to SQL Server using a Delphi program.
>> It ran fast and I created a few additional output fields. The data shows
>> up correctly in a Delphi Grid component using either ADO or dbXpress
>> connections. Weird that a linked table and our a query to the linked
>> table shows garbage while the pass through query shows all OK.
>>
>> I think it must be something in the ODBC link, but the pass through uses
>> the same one??
>>
>> Austin
>>
>>
>>
>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
>> wrote in message news:OjuzyVHeGHA.4128@TK2MSFTNGP05.phx.gbl...
>>> Another possibility would be the presence of a trigger. Did you choose
>>> DRI or Triggers when you made the upsizing?
>>>
>>> --
>>> Sylvain Lafontaine, ing.
>>> MVP - Technologies Virtual-PC
>>> E-mail: http://cerbermail.com/?QugbLEWINF
>>>
>>>
>>> "Austin" wrote in message
>>> news:e5XztuGeGHA.2416@TK2MSFTNGP03.phx.gbl...
>>>> Yes, I also subsequently thought of that and checked, but I use an auto
>>>> increment PK in SQL Server and it shows up in the Access definition of
>>>> the linked table. All the fields have "deleted" in them, the correct
>>>> number of records are returned. The pass through query works OK.
>>>> Weird???
>>>>
>>>> Austin
>>>>
>>>>
>>>>
>>>>
>>>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
>>>> wrote in message news:OVfIbOGeGHA.4932@TK2MSFTNGP03.phx.gbl...
>>>>> Maybe a missing primary key.
>>>>>
>>>>> --
>>>>> Sylvain Lafontaine, ing.
>>>>> MVP - Technologies Virtual-PC
>>>>> E-mail: http://cerbermail.com/?QugbLEWINF
>>>>>
>>>>>
>>>>> "Austin" wrote in message
>>>>> news:OqRHRmEeGHA.3388@TK2MSFTNGP05.phx.gbl...
>>>>>> Hi,
>>>>>>
>>>>>> I'm trying to use Acccess to get data fom MS SQL Server. I linked a
>>>>>> table and made a query, but the data appears as "DELETE" every where.
>>>>>> I tried a pass through query to the same table and it seems to work
>>>>>> OK????
>>>>>>
>>>>>> Can the SQL and Where be set with VBA for a pass through query?? Any
>>>>>> examples??
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> Austin
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
date: Tue, 16 May 2006 07:54:52 -0500
author: Austin
Re: Query to MS SQL Server 2000??
Hi Austin,
Almost always this situation is remedied
by adding a TimeStamp field to your table
so Access can play nice with returned keyset.
good luck,
gary
"Austin" wrote:
> Sylvain,
>
> The ODBC Connection, and the Access link were just created on the table.
> No changes to the underlying SQL Server table. When creating the pass
> through query, I thought I used the same ODBC connection.
>
> Austin
>
>
> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> wrote in message news:uIeU0PKeGHA.3996@TK2MSFTNGP04.phx.gbl...
>> The pass-through doesn't use the linked table at all and display the
>> resultset as created and returned by the SQL-Server.
>>
>> The problem may come from the additional fields that you have created on
>> the table: did you take the precaution of refreshing the link after you
>> created them?
>>
>> --
>> Sylvain Lafontaine, ing.
>> MVP - Technologies Virtual-PC
>> E-mail: http://cerbermail.com/?QugbLEWINF
>>
>>
>> "Austin" wrote in message
>> news:uxspahHeGHA.3948@TK2MSFTNGP03.phx.gbl...
>>> No, I pumped the data from an AS400 to SQL Server using a Delphi
>>> program. It ran fast and I created a few additional output fields. The
>>> data shows up correctly in a Delphi Grid component using either ADO or
>>> dbXpress connections. Weird that a linked table and our a query to the
>>> linked table shows garbage while the pass through query shows all OK.
>>>
>>> I think it must be something in the ODBC link, but the pass through uses
>>> the same one??
>>>
>>> Austin
>>>
>>>
>>>
>>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
>>> wrote in message news:OjuzyVHeGHA.4128@TK2MSFTNGP05.phx.gbl...
>>>> Another possibility would be the presence of a trigger. Did you choose
>>>> DRI or Triggers when you made the upsizing?
>>>>
>>>> --
>>>> Sylvain Lafontaine, ing.
>>>> MVP - Technologies Virtual-PC
>>>> E-mail: http://cerbermail.com/?QugbLEWINF
>>>>
>>>>
>>>> "Austin" wrote in message
>>>> news:e5XztuGeGHA.2416@TK2MSFTNGP03.phx.gbl...
>>>>> Yes, I also subsequently thought of that and checked, but I use an
>>>>> auto increment PK in SQL Server and it shows up in the Access
>>>>> definition of the linked table. All the fields have "deleted" in them,
>>>>> the correct number of records are returned. The pass through query
>>>>> works OK. Weird???
>>>>>
>>>>> Austin
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam
>>>>> please)> wrote in message
>>>>> news:OVfIbOGeGHA.4932@TK2MSFTNGP03.phx.gbl...
>>>>>> Maybe a missing primary key.
>>>>>>
>>>>>> --
>>>>>> Sylvain Lafontaine, ing.
>>>>>> MVP - Technologies Virtual-PC
>>>>>> E-mail: http://cerbermail.com/?QugbLEWINF
>>>>>>
>>>>>>
>>>>>> "Austin" wrote in message
>>>>>> news:OqRHRmEeGHA.3388@TK2MSFTNGP05.phx.gbl...
>>>>>>> Hi,
>>>>>>>
>>>>>>> I'm trying to use Acccess to get data fom MS SQL Server. I linked a
>>>>>>> table and made a query, but the data appears as "DELETE" every
>>>>>>> where. I tried a pass through query to the same table and it seems
>>>>>>> to work OK????
>>>>>>>
>>>>>>> Can the SQL and Where be set with VBA for a pass through query?? Any
>>>>>>> examples??
>>>>>>>
>>>>>>> Thanks,
>>>>>>>
>>>>>>> Austin
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
date: Wed, 17 May 2006 03:45:16 -0500
author: Gary Walter
Re: Query to MS SQL Server 2000??
> Can the SQL and Where be set with VBA for a pass through query?? Any
> examples??
here be a simple mdb example of how I
use a passthrough query to a stored
procedure for a report.
(remember that a passthrough is read-only)
On SQL Server, I have a stored procedure
SP_RPT_ITEMINFO
that expects one parameter -- @sku
In query designer, I set up and saved a passthrough query
"qryProcGetSKUInfo"
exec SP_RPT_ITEMINFO @sku=10009765
I then wrote a function that accepts a SKU,
rewrites the passthrough query using this SKU,
then saves results of this newly-defined passthrough
to a table that the report is based on:
'*** start code ***
Public Function fGetSKUInfo(pSKU As Variant) As Boolean
On Error GoTo Err_fGetSKUInfo
'be sure reference to DAO is set
Dim sSQL As String
'redefine passthrough to stored proc
sSQL = "exec SP_RPT_ITEMINFO"
If Len(Trim(pSKU & "")) > 0 Then
sSQL = sSQL & " @sku=" & pSKU
Else
fGetSKUInfo = False
Exit Function
End If
CurrentDb.QueryDefs("qryProcGetSKUInfo").SQL = sSQL
'save to tblSKUInfo (which report is based on)
CurrentDb.Execute "DELETE * FROM tblSKUInfo", dbFailOnError
sSQL = "INSERT INTO tblSKUInfo ( SKU, LocationID, Subsystem, Binding, "
_
& "Department, Class, Category, ISBN, Imprint, Edition,
Copyright, Vendor, " _
& "Description, Barcode, Comment, Location, QtyOnHand,
QtyOnOrderPO, " _
& "QtyOnPropOrderPO, QtyOnPropReturn, QtyOnOrderMR, " _
& "QtyOnPropOrderMR, LastSaleDate, LastInvDate, Cost, Margin, " _
& "Retail, QtyAfterSales, Status, StatusDate ) " _
& "SELECT P.SKU, P.LocationID, P.Subsystem, P.Binding, " _
& "P.Department, P.Class, P.Category, P.ISBN, P.Imprint,
P.Edition, " _
& "P.Copyright, P.Vendor, P.Description, P.Barcode, P.Comment, "
_
& "P.Location, P.QtyOnHand, P.QtyOnOrderPO, " _
& "P.QtyOnPropOrderPO, P.QtyOnPropReturn, P.QtyOnOrderMR, " _
& "P.QtyOnPropOrderMR, P.LastSaleDate, P.LastInvDate, P.Cost,
P.Margin, " _
& "P.Retail, P.QtyAfterSales, P.Status, P.StatusDate " _
& "FROM qryProcGetSKUInfo AS P;"
CurrentDb.Execute sSQL, dbFailOnError
fGetSKUInfo = True
Exit_fGetSKUInfo:
Exit Function
Err_fGetSKUInfo:
fGetSKUInfo = False
MsgBox Err.Description
Resume Exit_fGetSKUInfo
End Function
'*** end code ***
So...in code event where I open report...
(where "SKU" is a field of recordsource of the form
where I run this code)
If fGetSKUInfo(Me.SKU) = True Then
DoCmd.OpenReport "rptSKUInfo", acViewPreview
Else
MsgBox "Could not get SKU Info."
End If
Does that help?
/////////////////////////////////////
also, here be a sage past post from Joe Fallon:
***quote***
Every table in SQL Server should always have a PK and a timestamp field in
order to interact best with Access.
The timestamp is a data type, but it is not Date/Time!!
The timestamp is changed to a unique value whenever a row is modified.
If you add it to the table, then Access will use it "silently" to check to
see if anyone has changed the record since it was downloaded. (In other
words, the timestamp field does not need to be part of the SELECT
statement.)
Access compares the timestamp it downloaded to the current one and then
allows the update.
When there is no timestamp field, Access has to check *every* field in that
row to see if the data has changed. Not only is this slow, it often fails
due to decimal data type inaccuracies. (This is the Write conflict error you
are getting.)
Also, check your table to see if you have a boolean field that is type
"Bit". If you have any Bit fields, they MUST have a default value and MUST
NOT be null.
See the following MS KB article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;278696
For a Microsoft Access 2000 version of this article, see:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;280730
--
Joe Fallon
Access MVP
***unquote***
also...
From Mary Chipman's (and Andy Baron)
"Microsoft Access Developer's Guide to SQL Server" pg. 24
(highly recommend, it really helped me)
"The timestamp (or rowversion) column in SQL Server isn't about
keeping time, and the values that are used cannot even be translated
into standard date/time values. Instead, it is simply an efficient
binary field that's maintained automatically by SQL Server to
uniquely identify progressive versions of each row in a table.
SQL Server adds timestamps to tables with text (memo)
or binary (OLE Object) fields so that it can figure out if a
record has been edited without having to load the potentially
huge amount of data stored in the field itself.
Adding timestamps enhances performance with tables
containing floating-point numbers, OLE Object (binary) fields,
or Memo (text) fields."
///////////////////
Please respond back if I have misunderstood
or something was not clear.
Good luck,
Gary Walter
date: Wed, 17 May 2006 04:47:24 -0500
author: Gary Walter
Re: Query to MS SQL Server 2000??
I really don't understand why your linked table doesn't work. You may try
removing and relinking it to make sure that everything are as they should
be. A good idea might be to use the SQL-Profiler to see what happens on the
Server.
Instead of the linked table, you might use a QueryDef; however, this require
that you set up the full sql string every time you will have a change in
parameters. Also, the QueryDef will be read only, so I'm not sure if this
what's you want for your bound forms.
You should investigate why your linked table doesn't work because this
feature is used regularly by a lot of other people without any problem.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Austin" wrote in message
news:e%232WqfOeGHA.3792@TK2MSFTNGP03.phx.gbl...
> Sylvain,
>
> The ODBC Connection, and the Access link were just created on the table.
> No changes to the underlying SQL Server table. When creating the pass
> through query, I thought I used the same ODBC connection.
>
> Austin
>
>
> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> wrote in message news:uIeU0PKeGHA.3996@TK2MSFTNGP04.phx.gbl...
>> The pass-through doesn't use the linked table at all and display the
>> resultset as created and returned by the SQL-Server.
>>
>> The problem may come from the additional fields that you have created on
>> the table: did you take the precaution of refreshing the link after you
>> created them?
>>
>> --
>> Sylvain Lafontaine, ing.
>> MVP - Technologies Virtual-PC
>> E-mail: http://cerbermail.com/?QugbLEWINF
>>
>>
>> "Austin" wrote in message
>> news:uxspahHeGHA.3948@TK2MSFTNGP03.phx.gbl...
>>> No, I pumped the data from an AS400 to SQL Server using a Delphi
>>> program. It ran fast and I created a few additional output fields. The
>>> data shows up correctly in a Delphi Grid component using either ADO or
>>> dbXpress connections. Weird that a linked table and our a query to the
>>> linked table shows garbage while the pass through query shows all OK.
>>>
>>> I think it must be something in the ODBC link, but the pass through uses
>>> the same one??
>>>
>>> Austin
>>>
>>>
>>>
>>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
>>> wrote in message news:OjuzyVHeGHA.4128@TK2MSFTNGP05.phx.gbl...
>>>> Another possibility would be the presence of a trigger. Did you choose
>>>> DRI or Triggers when you made the upsizing?
>>>>
>>>> --
>>>> Sylvain Lafontaine, ing.
>>>> MVP - Technologies Virtual-PC
>>>> E-mail: http://cerbermail.com/?QugbLEWINF
>>>>
>>>>
>>>> "Austin" wrote in message
>>>> news:e5XztuGeGHA.2416@TK2MSFTNGP03.phx.gbl...
>>>>> Yes, I also subsequently thought of that and checked, but I use an
>>>>> auto increment PK in SQL Server and it shows up in the Access
>>>>> definition of the linked table. All the fields have "deleted" in them,
>>>>> the correct number of records are returned. The pass through query
>>>>> works OK. Weird???
>>>>>
>>>>> Austin
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam
>>>>> please)> wrote in message
>>>>> news:OVfIbOGeGHA.4932@TK2MSFTNGP03.phx.gbl...
>>>>>> Maybe a missing primary key.
>>>>>>
>>>>>> --
>>>>>> Sylvain Lafontaine, ing.
>>>>>> MVP - Technologies Virtual-PC
>>>>>> E-mail: http://cerbermail.com/?QugbLEWINF
>>>>>>
>>>>>>
>>>>>> "Austin" wrote in message
>>>>>> news:OqRHRmEeGHA.3388@TK2MSFTNGP05.phx.gbl...
>>>>>>> Hi,
>>>>>>>
>>>>>>> I'm trying to use Acccess to get data fom MS SQL Server. I linked a
>>>>>>> table and made a query, but the data appears as "DELETE" every
>>>>>>> where. I tried a pass through query to the same table and it seems
>>>>>>> to work OK????
>>>>>>>
>>>>>>> Can the SQL and Where be set with VBA for a pass through query?? Any
>>>>>>> examples??
>>>>>>>
>>>>>>> Thanks,
>>>>>>>
>>>>>>> Austin
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
date: Wed, 17 May 2006 10:53:19 -0400
author: Sylvain Lafontaine sylvain aei ca (fill the blanks, no spam please)
|
|
