Recent content by dmassey

I found an answer to my second question here http://www.codeproject.com/KB/IP/ListNetworkComputers.aspx

I am using .net remoting in my application, and I want the user to be able to pick an available server from a list instead of having to know the computer name and type it in. Is there a way that I can discover Remoting servers on the local subnet that have a given port and topic? or Is there...

I am running windows 2000 and have a problem with my internet connections. When I am using the internet(Mozilla or IE) my internet fails after about 2 hours for sites that I haven't been to yet. Sites that I have already connected to remain working. When I ping from the dos prompt, I can ping...

Hi I have a large recordset that I am looping through using ado and Jet 3.51. The table is in an access 97 database. The code takes about 5 seconds to process the first 32000 records and then it slows to a crawl, looping through only about 10 records per second. I am using a clientside...

I was already doing that.(docmd.setwarnings false) It's more than just a warning because it asks for information. Derek

I just tested it using access 2000 and access2000 puts the 000103 before the 000-701886 I wasn't aware that access 2000 had a different sort order from 97. Maybe MDAC 2.6 isn't really meant to be used with access 97. Derek

rs.Open "Select ITNBR From table1 ORDER BY ITNBR" Puts 000-701886 before 000103 and rs.Open "Select ITNBR From table1", cn, adOpenDynamic, adLockOptimistic rs.Sort = "ITNBR ASC" puts 000103 before 000-7001886 I don't really know which is backwards, access97 sorts like the first example...

Hi CajunCenturion An example of two part numbers that would be sorted backwards is the following "000103 " and "000-701886 " These part numbers are text fields with trailing spaces as shown. It's not a big deal to use the client side cursors and sort everything the same way so...

Hi I am creating a linked table to an odbc datasource in access vba. When I create the link, access shows a windows with the title "Select Unique Record Identifier" and it gives a list of all the fields in the table to select from with OK and Cancel. All I need to do is click cancel and the...

Hi CajunCenturion I have tried putting an index in the access table but it seems like if I open an ado recordset with orderby in the sql statement it gives a different sort order than if I open the recordset with ado an then use a sort on the recordset itself. ie ppprs.Open "Select * From...

Thanks for the replies I realize that what I want to do here is kind of unusual. I am trying to optimize some queries on some huge tables through slow connections and it would have been nice to avoid the slowdown caused by the ORDER BY in the query. What I am trying to do is mirror an AS400...

Thanks, Mark That was exactly what I needed. I hadn't thought of the client side cursor. Derek

Hi I am using ado to add records to an access97 table using rs.addnew and rs.update Is there any way to insert the new row at a specific location in the recordset instead of at the end? Thanks, Derek

HI I am connecting to a table on an AS400 server using the following code: cn.ConnectionString = "Connect=ODBC;DSN=AS400 AMFLIB;UID=;PWD=;" rs.Open "Select ITNBR, ITDSC, UCDEF FROM AMFLIB.ITEMASA ORDER BY ITNBR", cn, adOpenDynamic, adLockOptimistic My problem is that the query is passed to...

I have been working on a problem very similar to this one. My problem was that I have a button on a continuous form that will delete or modify the record depending on certain criteria. After the button has been pressed, I needed the to requery the continuous form and be at the exact same...