hi. I dont have sqldmo.dll. possible to list all sqlserver on my lan? Tks

-access 2003. -Vb6 classic I cannot have permission Sql Server, but have only a redaing on the sql table. If for you is a god way to use DTS in vb code this solution is welcome! Yes if is possible make all wiyh vb6 classic. Tks.

With ado and vb6 classic. I have sql table with approx 4.500.000 records. How to copy all sql records into the access table via vb6 code, and with fasted method?

ok tks for reply... But i dont see where i insert the name of domain? :( :sigh:

http://www.codeproject.com/Forums/1646/Visual-Basic.aspx[^] http://www.codeproject.com/Messages/3464135/getting-complete-name-of-account-NT-server.aspx[^]

yes! just the user's name like John Smith

I know the name of Domain on NT platform "MY_Domain_name". I know the username "OU458778". Is possibile to know the complete name of username???? With vb6, please.

I have tested this way but the code run very, very slow... Tell me if thei prob is your and post me a vb6 code:-)

Hi Eddy.... tks for tip but sure not for me i know only VB6... Can you post a code to use with vb6 classic? Tks for patience. Sal.

Hi Eddy.... tks for tip but sure not for me i know only VB6... Can you post a code to use with vb6 classic? Tks for patience. Sal.

scenario: I have a Sql Server in Rome and a shared server dir (with the access database) on a Server in New York. I have permission on sever dir and databse. The database table on sql Server have exactlly the same structure of Access table database. (the table on Sql Server have 200.000 records and 48 columns). Now i want to recopy all records from Rome(sql server) to NewYork (Access database). Wath is the best way in terms of time to recopy all records fom sql server to access database. note: I want to use in my app the ADO drive and vb6 classic. naturally other way are welcome:-)

How to looping all items in combobox in a web page with a for next??? Just for example use one combobox from a web page wich you desire:-) I know Html Library and use the ie object

I use ie object to navigate in html page. Now in the a page of site here is a table with a button... When the user cklick on button the table is filled with a new data. I think... the Button clcik send a notice to a Data Server where are stored the recordset(?!) and retrive a string with data to insert in table... My question and dubt are: Is possible to intercept the string of data before the code insert into table? Is possible to intercept the source of data? the page of site are all in ASP. Tks.

but i need for vb6 classic, no net. tks.

hi... but i need for vb6 classic.... no net

How to colorize partial background of item in rowset of listview? example: have my_var=75 colorize 3/4 of item, have my_var=50 colorize 1/2 of itema, have my_var=72 colorize ecc... Similar a progressbar but stop for filling item based value in my_var...

How to colorize partial background of item in rowset of listview? example: have my_var=75 colorize 3/4 of item, have my_var=50 colorize 1/2 of itema, have my_var=72 colorize ecc... Similar a progressbar but stop for filling based value in my_var...

If i use ado and msacce mdb in c:\ all work fat but if i use the same code to read and write on md in \\myserver\mydir... all opertion are very very slow!!!!! PLease "10 gold rules" to speed up operation on network ! Tks.

modified on Saturday, January 31, 2009 1:51 PM

After the treeview is filled is possible to: count how may AG-xxxxx are in 8501-xxx, count how may items are in each AG-xxxxx, , count how may items are in each SETT. -xx, ....ecc and store the result in a var or count during the treeview is filling and return the result in a var in effect i want to count how many items are in each node with "+"... this is my code to fiull treeview: RSSQL2.MoveFirst Do Until RSSQL2.EOF sValue = Trim(RSSQL2.Fields("COD_AREA").value) sKey = "K" & sValue .Nodes.Add , , sKey, sValue & " - " & Trim(RSSQL2.Fields("DESCRIZIONE")), 1, 1 sValue = "AG. - " & Trim(RSSQL2.Fields("SPORT").value) 'sSQL = .Nodes.Count .Nodes.Add sKey, tvwChild, "L" & sValue, sValue & " - " & Trim(RSSQL2.Fields("DESCRIZIONE2")), 1, 2 sKey = "L" & sValue sValue = "SETT. - " & Trim(RSSQL2.Fields("PROVA3")) SSQL = .Nodes.Count .Nodes.Add sKey, tvwChild, "M" & sKey & sValue, sValue, 1, 2 sKey = "M" & sKey & sValue sValue = "COPE - " & Trim(RSSQL2.Fields("PROVA1")) .Nodes.Add sKey, tvwChild, "N" & sKey & sValue, sValue, 1, 2 '.Nodes.Item(sKey).EnsureVisible RSSQL2.MoveNext 'sSQL = .Nodes.Count Loop

ok... i want to get a part of single line with MID,LEFT,RIGHT ecc and store the piece of line in a var. About array mode, is simple one suggestion.. in Google i have seen with FSO is a good way to speed the reading or not?