VB Forum / Database Access / September 2003

I am trying to determine whether it is better to develop a database front
end to a SQL Server back end using an Access project (adp) or VB.NET.
Any opinions on this?
Thanks!

I have a vb.net application which runs fine when
installed locally on a user machine but when the
application is run from a network drive a security
exception error occurs.  I've set the intranet zone

I am using VB 6 and Access 97.
I know that I can import a file by using start and ending positions of
a text file. Long ago I saw someone use the OLE and Access to import a
text file into Access.

I have an application that is getting a random run-time
error 3421. According to the knowledge base, this is
related to passing a BLOB argument to a stored procedure
(Q190450). While my application uses a stored procedure,

I have to read information from Access DB and insert
record to Oracle9i table. I used VB and ODBC for Access
and Oracle and I did that. It is working find but it is
working very very slow!!!!!

I work in the IT department of a Finacial Institution,
and we have a couple of Access databases (Complaints,
Training Etc.)
I want to make a frontend so that these databases can be

Hi, I have this problem
All of a sudden my adodc control does not want to compile its own events
something like:
Private Sub AdodcVehicle_MoveComplete(ByVal adReason As

I'm using VB6 and MySQL database server, I work fine for select statement
and I can view the data but I can't "INSERT, UPDATE and DELETE" data at
MySQL database.
It return a error code "run-time error 3251, current recordset does not

VB6, Access table, screen fills OK on load (ListIndex = 0 , select *)
When i try to set an order, like in ListIndex = 2, pooooof debugger
What am i doing wrong?
If cmbNiveau.ListIndex = 0 Then

I have written a vb6 program that I was to use to perform
searches on a database.  I want the user to enter data
into a text box, and then use that infor in an SQL query.  
But, if the user enters TEST in the textbox, I want to

How can I create a chart with vb through odbc ms access
database (.mdb).
Thank you for solving my problem.

My application begins with a form that shows all open orders to the user.
The user can either select an existing order or click a cmdbutton to
enter a new order.
When first deployed there are no orders to display. The app uses an sql

I'm new to VB, trying to Import data in text file in to an access
database using a "schema.ini". But my text file has two types of rows
(please refer attached zip file - zipped text file). First row is a
summary of the all other text rows which has less number of columns than

I'm new to VB and database programing but I have a project
that needs to use SQL(MSDE).  Using ADO to connect what
connection string do I use?  Also, if the database (SQL
(MSDE)) is installed locally what would the database path

I need to run SQL on two recordsets. For example:
1. Recordset 1 - [CUSTOMER]
Recordset 1 is to capture [Customers] table
2. Recordset 2 - [ITEMS ORDERED]