VB Forum / Database Access / December 2005

I open an ADODB recordset rs and want to determine if a particular field is
present in the recordset. For example rs.Fields("ClientID"). I want to do
something if the field is in the recordset and move on if not. How can I do
that?

Hello Sir,
How to open password-protected ACCESS-2000 database,
using ADO2.0 or ADO2.5 library
With sharing mode through my VB6 Application.

I am using SQL Server 2000, VB6, and ADO recordset. I have a table
containing a column with datatype of timestamp. I open my ADO
connection by specifying client cursor location. The recordset is
opened with static cursor type and batch optimistic lock type.

How Can i add a new filed_name within Access2000 database table or modify a
field_name, By my VB6 application.
Kindly Help me.
Thank you

Here's what I need to do.  I have 2 different databases, an Access 97 db and
a FoxPro 6 db.  I need to run a query that finds records in the FoxPro db
that match a certain condition in the Access db.  Is this possible using
ADO?  If so, can someone provide an example?  Thanks in ...

I am trying to validate the data that is input into my database through VB.  
I currently have the following:
'MALE PULLUPS
If [PULLUPSBENTARMHANG] < "21" Then

I had a few thousand messages in this newsgroup up until a few days ago. I
now only have 43. What happened????? Did I just lose all that helpful
information??

Hi,
I want to store data on my Pocket PC in an SDF file and then use ActiveSync
(4.0) to have that SDF file synced to the sdesktop. Now, I need some way to
read that SDF file on the Desktop and populate and Access database.

    I am trying to create MS Access databases using VB .net. I can create
MS Access 2000 databases OK but also want to create (using VB .net code)
97 format MS Access databases as well.
Was using ADOX but the create statement has no parameters for access

I have just created a SQL server database with tables/stored procedure etc.
I need a simple way of installing this database in several client locations
based on server name or instance name.
Can this be done directly from ADO sending a script to SQL server ?

My client wants to scroll up and down instead of sideways when filling
in information.
Will the MSFlexGrid do this?  Or any of the other grids that come with
VB 6?

I have a win 2003 server installed in my office. In my office, I can
add server by using server's name, but I cann't add server by using
server's IP address.  I try to add server by using IP address at home,
I will always get xxx-xxx-xxx-xxx server error. But I can use visual

How do I save the path of an image into ms sql database? Through a web form
ASP, asp.net, or C#
A sample project would really help as I am struggling. I have read it is
best to save images in a folder. How do I make the image corresponding to

I maintain code written in VB 6.0. It uses ADODC to access a database in
SQL-server. Data is beeing displayed on the forms with datagrids bound to the
datacontrols. With adodc it's possible to move next, previous, first and
last.

Using VB 2005 with ADO.NET, how can you create an OdbcConnection without a
specific ConnectionString? I want to allow the user to select one of the data
sources from ODBC Driver List.
Thanks,