VB Forum / Database Access / December 2006

Application trying to develop in VB6   and  Access97 Database.
Connected through ODBC  - dsn  Connnection to the Server Database
Seek and Index methods rises and error message that Provider not
support this Method.

My VB5 app uses an Access 97 database located on a shared drive.  At certain
times, the app also uses a small 97 .mdb in a folder on the user's local c
drive.  When properly installed on some new Fujitsu workstations, the app
fails when trying to open this local .mdb with the ...

I have a problem that I am importing a delimited text file into access
table using schema, but when I import all the spaces are trimmed in all
the fields.
can anyone help me to import as it in the text file... ?

I'm getting an out of stack error when I use the BOF,EOF,Forward & Back buttons on a ADO Data control.  I have a Datagrid bound (early binding).
When I press the buttons, I captyure the data by examining the Datagrid.  Everything works fine for about 20 clicks of the above ...

I am using MS Access forms as a front end to a backend SQL Server
Database.  I am trying to use an ADO connection to return a Select
Statement from the SQL Server to an Access form to be viewable by the
user.  I have been able to establish the connection to the SQL Server

I have a VB 6.0 small application.  First the user can create new record or
open existing record.  I have a search form that asks the user for the
report number or title of the record.  then the record is listed on ListView
which then can be selected to open report or record with ...

How do I inject a DLL into a program at run-time? Basically I have a
folder that has an unknown amount of DLLs in it (can have 0 or could
have 100) and I want to be able to inject every single DLL at
application start-up? How can I go about this?

I have tried everything with updating a database record and it still
errors on the date.
I have tried the following
SQL_query_courseUpd =  "UPDATE courses SET date = '#" & date1 & "#'

...which has a command object as its source.
Is the error mesage that is currently driving me nutty. Let me explain.
The function causing the problem is as follows:
Public Type SPDataset

Hi me again,
Anyone who can see what I can't?
SkoRent.Adress is a 20-char string
Datum$ is "061210"

I am getting "Out of Memory" error when i check the recordcount of a
recordset object and also when i do a rs.addNew. The main thing here is the
table which i am quering has around 550 fields and this issue occurs only
when almost 250 fields have data in them and the real concern ...

Ok here's a good one.
I have an ADODB table that I need to copy into an RDO table. Do I have to
write the code to read each row from the ADODB table and create a new row in
the RDO table? Or is there a trick that I can do this without looping

I'm working on a Visual Basic 6.0 Application and using Access 2003
database. I can run the application in the design mode and every thing
works fine, but when i make it an .exe file it will give me the runtime
error 3021? i'm using ADODC connection to the database and to the

I need to connect my Pocket PC (Datalogic JET, Windows CE .net 4.2) to
Oracle using Visual Studio .net 2003. How can I do that?
Thanx!

I have an application which uses a temporary MDB for processing, and I
use ADO.
The app create the temp mdb from a resource mdb, populate it with data
read from CSV files, perform the processing, export the results to CSV