Recent content by ranne

Hi, This may be easy, but I can't seem to find the solution. When importing a file into a datagrid, I want the user to have the option to choose whether there are column headers in the file. If there are no column headers, then I want the datagrid to have default headers, and the 1st row...

Thanks! A client-side cursor did the trick. I'll have to ask about switching to MSDE because speed is still an issue and Access has been nothing but problems. Thanks again.

Not sure. In sql, I have an id column primary key, another index for the x & y columns and a 3rd index for the 5 columns that make up the location. In access, there are the same columns but they are indexed individually. Is there a better way to index them? I need to query the database...

Thanks for the ideas. Since I need to have the database in both Access and sql server, I want basically the same code for each situation. The reason that I take in a larger recordset (2000 points) is that I need to find about 25 points that have varying criteria depending on where they are...

So other than switching databases :), what would be a way to remedy this? The database is very large (~4 million points), but the queries to sql server are relatively quick. It's just once I get the recordset back into vb, I search the recordset using a bunch of filters and it takes a long...

Hi! I am working on a program in vb6. When I apply filters to a recordset from an access database the filters are relatively quick, but when I open a recordset from the same database on sql server the filters are extremely slow. Does anyone know the reason for this? The recordsets have the...

Hi, I'm trying to compile c++ code with MS VC++ (and Borland) compiler. However, every time I get a notification :" 'outp' has no prototype. What options do I have? Can I replace the inp and outp command with some other ones? Is there possible a library, that I have to add? thanks