VB Forum / Database Access / October 2007

How can I connect (client side) to my access 2003 database using a web
page?  I've searched the web and I'm looking for bare bones examples
to: 1) connect 2) display data 3) update data 4) delete data.  HELP!!!

I'm a VB6 developer who has recently installed Visual Studio 2005 and I want
to get my hands dirty with VB.NET 2005! I'm struggling with database
connections, and I mean floundering!
Most of the examples I've found have been using forms and controls but I

I am using SQL2000 and asp.net using vb.
I am returning a value for the number of records in a recordset that I am
binding to a datagrid but am not sure how to bring back value from SP.
Code for binding data from SP to grid:

I have a command in a vb method that saves data to an sql 2k database as
follows.
   Dim rs As ADODB.Recordset
   Dim strSQL As String

Running SQL 2000...I'm writing some VB code (actually VBA) using ADO to
connect to SQL.  I want to override the regular SQL Hostname -- which
normally displays the workstation ID -- with my own string, specified as
an arg to ADO's ConnectionString property.  I wasn't sure if I ...

I am very new to using code to build forms and am having a problem.  I
trying to embed a query within a public sub routine.  The goal of this
query is to use an alphanumeric code entered into a combo box on a
form to retrieve an associated ID within a table that will be used

Option Explicit
Dim ws As Workspace
Dim db As Database
Dim rs As Recordset

I have an application in VB6 using DataEnvironment object to specify the
connection to a different databases.
Up to now I successfully made connections to a Access, Oracle and SQL Server
databases.

Dear Sir,
I Want to Open dBase III files. Now How I can provide connection string
without using User DSN
Sanjay Shah

A simple VBScript with the line:
Set oFld = CreateObject("ADODB.Field")
causes an error that the object cannot be created. I've seen various
examples of this so I'm sure it must work. Can anyone tell me why this

hoping somebody can help out here. Searched half earth to find a
solution but no success yet. The following code doesn't gave any fault
or warning but doesn't what it is suppose to do.
Can somebody explain why this code does not produce an extra new row in

Hi,
This is actually an MS Access problem, but i thought i'd put it here as
well. If anyone can help....
I am working on a database and on a specific form i have a button for

Hello,,
Iam just trying to read a sheet from excel and transfer that excel
information into my Access database.
When i try to import the excel data Iam getting Object variable or with

Hello,,
Iam just trying to read a sheet from excel and transfer that excel
information into my Access database.
When i try to import the excel data Iam getting Object variable or with

Using this connection string from Vb.net 2005 runs successfully:
"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Program
Files\SQLTest\Database1.mdf;Integrated Security=True;User Instance=True"
I have gone to a previous application written in VB 6 to replace Jet/ACCESS