Search results

  1. W

    Bulk Insert ADO Recordset into Linked SQL Server table

    I'm dealing with 100-10,000 records at a time. I'm trying to break it up as I go through over 1,000,000 records that need processing, each one returning 8-10 records out of Sybase. I've linked the Sybase tables and am attempting to run Access/Jet sql from the Linked Sybase tables to the Linked...
  2. W

    Bulk Insert ADO Recordset into Linked SQL Server table

    I've been crawling the web but I can't seem to pin an answer down for my situation... Currently I use an ADODB.Recordset to gather info from a Sybase connection with the ADO recordset, I then loop through each record and perform an insert. Do while Adodata.eof = false docmd.runsql "INSERT...
  3. W

    Listview properties won't save

    Nevermind - I found that if I used the "property sheet" it wouldn't save, but if I right clicked on the listview itself, selected properties, made adjustments and clicked "apply"...it saved. Not sure why that way works and the other doesn't, but at least it's problem solved.
  4. W

    Listview properties won't save

    Hello,I'm just learning how to populate listviews and am using a demo to guide me...but I noticed that when I save the properites (grids, multi select, etc) in the design view, I'll save with ctrl+s and right_click save on the form...close the form...and when I open it, the listview properties...
Back
Top Bottom