VB Forum / Database Access / December 2004

I have a piece of code where i'm inserting a single row in a table and  
then using the Connection Objects Execute method to get the @@identity  
from the table.
This worked fine, until i was asked to change the connection string.

I am trying to run a function in an Access MDE from vb6.  Running the
following code works fine in an MDB:
Set appAccess = GetObject("Reports.MDB").Application
appAccess.Run "MyCustomFunction", arg1, arg2

I am trying to develop a small application. The database is Access. This is
over a network in another system. After it is developed, 2 or 3 of my friends
will access the database.
How will i create a connection in Visual Basic using ADO so that the

I am doing research on a possible project that may come up
in January that consists of building a front end in vb6 that will
access data on a remote PC with Windows Server 2003 and
SQL Server 2000. The only common denominator is that all

We are creating a form for our VB 6 app users to edit some add and edit some
data over a WAN connection to a SQL Server.  What is the best method to set
up the ADO objects under these circumstances?  Specifically:
1.  I am assuming that the Connection object should only be opened ...

I have a VB 6 app which creates an ADODB.Recordset.  I need to pass this
ADODB.Recordset inot a .Net Web Service.  I know that the recordset cannot be
passed in its original form.  How can I transform this ADODB.Recordset into a
format that can be passed as a parameter into a Web ...

my question isn't db related but here i get the fastest answer...
i am making a document with 'printer'
printer.print variable
i would like help on changing the font type and size (to arial size 10)

Why are there no wizards in .net
There are no addins No Toolbar Wiz, No App Wiz, no Class wiz Why?

In this query below, we can only write down a string without any
space, but if I want to write 2 strings? Like this:
SELECT * FROM table WHERE field = T Anderson
Regards,

I create a database using  DAO with one table.
After that my app. stores data to this table.
But i need a sorted table to work with. Now i'am using a query, but with
about 4,000,000 records

Hello - I have a problem that I'm trying to address in VB6 and I'm
soliciting feedback from others to determine the best algorithm to use.
We currently have an online application that must be "enabled" at start of
day so users can access application.  At end of day, the ...

newbie ?: is it possible for a database like access or msde or sql server
express  to raise an event to an application? i would like to detect if a new
record has been added to a table automatically, using events? is this
possible? my goal is to have a listview update ...

Thanks as always for your response in advance.
Here's my situation:
I'm using vb.net with a MS SQL database.  We enter new records
beginning with the SSN - Social Security #. The SSN is stored as a char

Hey all,
I'm doing some modifications on an old VB 5.0 application.
The current code to access an MSAccess DB is :
rsName.Index = Column1

I have a VB6SP5 app written with ADO and using MDAC 2.7
After install on 5 Windows XP machines with Office XP, on of then showed the
error on the subject ("Method '~' of Object '~' Failed")
Some foruns suggested a MDAC version mismatch or DLL mismatch