Recent content by gorack

current recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. My code is in VBSCRIPT i create a connection then Set rs = CreateObject("ADODB.Recordset") rs.Open "table", SourceConn, adOpenDynamic rs.addnew the addnew...

Thanx! I forgot the TRUNCATE TABLE command hehheh

why ?

If i need to convert an access application (query, tables, codes...) in SQL SERVER 2000 and i need to make code, what is the better solution (with performance and portability in mind)? -Stored procedures (cursor is slow) -VBScript or a VB PACKAGE in DTS ?

Incorrect syntax near '*' when i try to delete from a sql server 2000 table

It's surely not a network connection because the sql server 2000 is local. Tere is no DBA who can help me ?

I am de dba and programmer of the datawarehouse. So i must know why in vb6 in the data window it work (delete, insert or update) ? i use the same connection as in vb6 use.

sql sister how do i do that ? with the login ?

I have a data warehouse in my workstation in sql server 2000. I installed Sql server 2000 with windows nt authentication. I create a database and i create tables. In sql server 2000, when i create stored procedure and i insert, delete or update table it's fine. But when i use access with an...

Why i can't insert, delete or update in a sql server 2000 database with an odbc connection or an ole db connection (ADO) ?