Search results for query: *

I need a T-SQL routine that takes Table1 in this format: ( DUNS [char] (9)-with duplicate values, INDICATOR [char] (4)- ) 111111111 abc1 111111111 abc2 111111111 abc3 ..................... 111111111 abc6 222222222 def1 222222222 def2 222222222 def3 333333333 ghi1 and creates a new table...

I think that my problem was Access 97; the ODBC connectivity doesn't work properly from within Access 97 I've changed to Access 2000 and it worked. But , if you create for example a SQL-PAS Through Query go to View->Properties->ODBC Timeout Hope this help Good Luck Cris

The output must go into Access 2000 format. My question is why DTS Export Wizard fails and why the Access database reaches maximum size only after 500k records My guess is that besides the data it also exports the properties of the table. The same amount of information but coming fom a flat...

Hi all, I have a SQL Server table with 1.2 milion records. All fields are char type with max record length 1066 bytes . I need to export this table into Access 2000.I'm using DTS Wizard and after 500,000 records the process fails with an error: ".... Invalid argument" The Access...

The problem it's on client side I have the latest MDAC on both machine. Thanks, Cris

I have a simple select query(Q1) that uses 2 linked tables T1 and T2(from SQL Server 2000): SELECT T1.* , T2.Field1,T2.Field2 FROM T1 LEFT JOIN T2 ON T1.Field1 = T2.Field1 I use then Q1 and T2 to create another query(Q2)- Q2 calls Q1) SELECT Q1.Field1 FROM Q1 INNER JOIN T2 ON...

I have an application with front-end Access 2000 and back-end SQL Server. I am using linked tables through ODBC. I've created a simple select query(qry1) based on 2 linked tables. It worked fine on both system(Win 2k and Win NT) Now if I tried to create another select query based on qry1 and a...

response for zionman4 what i've done : i have a recordset rs with 1 record before I had : Public Function OutputDelivered(projectid As Integer) As Integer .... With rs .... OutputDelivered=value End With End Fuction and I modified the code like this Public Function...

Hi ssecca, same result with Me.Output_Delivered.value = OutputDelivered(Me.[Proposal Tracking Number].value) why if i pass the value like this , it's ok Me.Output_Delivered = OutputDelivered(123) any further suggestions ? cris

I have a function that takes an Int returns an Int after calculation Public Function OutputDelivered(ProjectID As Integer) As Integer On a form I have 3 controls : R1,[Proposal Traking Number] and the last one [Output_Delivered] In R1_AfterUpdate event , i try to call the function code...

Hi Qatqat, I've tried also text on SQL ,but using this type I've got an error message : ODBC--called failed when I open the linked table in Access and #Name? in all records. If I use ntext there is no error message , but I'm restricted to Text(255) Any further suggestion ? Regards, Criss

Scenario - Access97/Access2000: I've created a table with one field type MEMO;I upsized the table to SQL Server 2000 using DTS ; The field went to ntext(16) by default, which is correct though; I linked back the table to Access 97/2000 through ODBC (User DSN) and ... the field is NOW type...

Hi Ann, I've tried different version: by default it goes to ntext(16) as I specified before I've also tried with text, nvarchar... Same result: -on the design view of the linked table the field is Text(255) So does anybody now if there is a solution for this issue ??? Cris

I have a table in Access 97(100+ fields) and one of the field is type "MEMO" I upsized the table to SQL Server 2000. The correspondent field on SQL is type "ntext" which is correct. I linked back the table in Access 97 through ODBC. In design view(Access 97) the field is now...

I have a table in Access 97(100+ fields) and one of the field is type "MEMO" I upsized the table to SQL Server 2000 using DTS. The correspondent field on SQL is type "ntext(16)" which is correct. I linked back the table in Access 97 through ODBC. In design view(Access 97) the...

I have a table in SQL Server 2000 that has a field in it of type "ntext". When I try to open the linked table through ODBC using Access97, all that appears for each field in some of the rows is "#Name?" and the error message " ODBC-call failed(error 3146)" Design...

I have a table in SQL Server 2000 that has a field in it of type "ntext". When I try to open the linked table through ODBC using Access97 all that appears for each field in some of the rows is "#Name?" and the error message ODBC-call failed(error 3146) Design view of the...

I have an Access97 application: The front-end is developed in Access97 and the back-end is SQL Server 2000(I migrated all the tables from Access 97 to SQL) When I try to modify/update a record after a while I’ve got ODBC-call failed (Error 3146) I’m not sure , but it seems that the error is...

I have an Access97 db & ABC a query I use the following code code to display the results into an MSHFlexGrid. Why is it displayed JUST the first record ???? What is it wrong ??? Private Sub cmdReport_Click() Dim rs As ADODB.Recordset Dim cmdobj As ADODB.Command Set rs =...

Steve, Belive me, you can do!!!!!!! Try and see. The only restriction is DisplayMsg = True , otherwise you'll get that error message. So... again WHY ???????????????? And by the way .... is nobody on this forum who had this problem before ??????????? Thx for your time Cris