VB Forum / Database Access / September 2004

My VB.Net application needs to compose and execute bulk insert statements. It
works just fine when the application runs on the same machine as the database
(...FROM c:\filename.txt ...). However, the application needs to run on
multiple machines on the network.

I'm new to working with ADO (v2.7). I'm connecting to a MS SQL Server
database. I'm creating the table programatically. I already learnt how to
create the columns. I'd like the first column to be the primary key that
automatically increments and is unique.

Absolute beginner, trying to establish my first connection to a Jet
database. The routine fails with the above message at the line:
Dim conn1 As New OleDbConnection(connstring)
Any help appreciated.

I'm writing some ASP that uses the Jet 4.0 connection string (with an
Access 2000 database), which needs to work on all versions of Windows
98 onwards, according to Microsoft Jet 4.0 isn't shipped with MDAC 2.6
onwards:

Hi I am trying to execute an SQL statement from VB 6.0 to MS access.  The SQL statement
contains the clause insert into.  The connection i have used is dao. However it seems that every SQL can be executed
but not the ones that have the insert statement. Can anyone help?

I have a visual basic 3.0 application that accesses data in an Access 2.0
database. When I convert this database to Access 97 I get an error running
the application - unrecognizable database format. Is there some way I can get
round this so it will work?

can someone help me with opening a recordset for SQL sever using DAO, from
VB. It needs to be opened for writing, and it needs to work.  Don't ask why I
don't use ADO -normally I would, but we've got this huge load of code that
uses DAO with Access, and uses a dongled DLL which ...

I want to create a tab delimited file.
If I do it through access, i have :
DoCmd.TransferText
acExportDelim, "myspec", "one", "c:\test.txt", False, ""

I am a novice with VB6 and Access Databases.  I am looking at how to write
a program in VB6 which will track information and will add, delete, and
updated this information to the access DB as needed.
Also, I am interested in how to read a value from a field in an access DB

The problem below has been haunting me since 2001, but programming isn't
really my job function anymore and I really haven't had time to dig into it
as well as I probably could. What digging I have done has not helped--and
much of what I have learned has been forgotten and ...

I'm writing a VB6 application that parses a text file, loads the data into an
intermediate Access database, and then synchronizes the data with a Palm OS
device via the Palm Conduit Developer Kit.  (The Palm aspect is probably
unimportant)

Mybe a stupid question but a try to update a dataset with the use of a
normal variable for instant a string var. Normaly it is a formcontrole
as a textbox that does the job but i want to use a stringvar in
runtime

I noticed ADO doing something that I think is pretty dumb: if you filter a
recordset on adFilterPendingRecords, but no records are pending (i.e., no
changes have been made since the last UpdateBatch) the filter returns all
records!  That's a real bummer as it causes my code to ...

I have an alphanumeric field I'm trying to sort by, and the query runs
exactly the way it is supposed to.  But I was hoping there is a way to change
the way ADO sorts.
Here is an example of a Query:

To the following procedure we have added transaction processing and since
that point a lot of customers are getting the error -
3034 You tried to commit or rollback a transaction without first beginning a
transaction.