VB Forum / Database Access / October 2003

Hi Group,
Anybody know of any freeware code to allow me to emulate a VT420 screen
within Visual Basic?
Regards

We are trying to figure out how secure an ADO (we are using 2.6) RecordSet's
data is.
Does the ADO RecordSet data get Encrypted?
If so, is it pretty secure? Our application uses ADO to retrieve and send

Hello everyone, I'm new to VB and would like to know how I
could connect to my Access Database called NRData.mdb.  I
would like to view a column called Symbol in a table
called tblqData.

I have a function that I need to return multiple record sets from.  Within
the Function I need to open four recordsets and pass them back.  I was
thinking of using an array of recordsets, however, some of these recordsets
can be large.  Any suggestions? PSEUDOCODE BELOW:

I have a need and desire to learn more about database programming.  I
have a rudimentary knowledge currently.
My needs are for more sophisticated database interface, more than can be
done with, e.g., MS Access's built in capabilities.  This will be both

Does anyone know how to create a completely unbound recordset using ADO(X).
Our mainframe doesn't support ODBC, RDO, or ADO, so we had to roll our own
middleware.  I can get the records from the mainframe, but need to be able
to print the data from various VB controls.  I'd like to ...

I appreciate any help on this.
I have 2 forms, one has a combo box on it. combo1. The other has a adodc
control connected to an access database.
When I select a field in combo1, I would like to open up form2 with a

Can someone show a better way to make sure a table exists before trying to
delete it?
   For Each tbl In cat.Tables
       If tbl.Name = newTableName Then cat.Tables.Delete newTableName

I've been using DAO for my database projects, but decided to dive into ADO
for my latest project.  And, not surprisingly, I've run into a couple of
problems.  The main problem that plauges me at the moment is my inablility
to open an Access 97 table via ADO.  I have an Access DB ...

Program creates table via ADOX, needs to assign Primary key to one of the
created fields.  MSDN sample shows ForeignKey well enough, but not enough
info (for me at least) to figure out Primary key creation.
Can anyone supply a snippet for assigning/creating a primary key via ADO/X?

In ADO, can you cancel the .Open Method of retrieving a recordset?
----------------------------------------------------------------------------
-----------------------
Dim rst As New ADODB.Recordset

I have a Recordset that I have applied a Filter to, now I want to delete
that "Filtered" set of records.  It seems fairly straight forward, but when
I call the delete method on the RecordSet I get the message -
Run-time error '3219':

I am trying to insert a new record using the Command object and one of the
parameters is a adLongParam type (text).
Executing the Command object fails saying that the parameter is incorrect.
Is it only usable on an existing record?

I am querying a SQL2000 recordset to detirmine if a
customer reference exists from a string entered in by a
user. I have tested this with a full reference and a
partial reference, and get find the number of records i

Any body Pls Help me with SQL syntax
SELECT Equipment.EquipmentName, Equipment.SerialNumber,
Equipment.ModelNumber, Equipment.[Present Location],
Equipment.[PM Date]