VB Forum / Database Access / March 2006

Currently i have a VB6 (SP6) application that accessed and updates tables in
a SQL2000 server using ADO. This works fine  however when try to run the same
cose against a SQL2005 server i come up with a problem i dont understand.
AAgainst the SQL 2000 this peice of code which ...

How to made RTF file through My VB application.
and 2nd thing is i want to make RTF with diffrent Font name and size.
After creation how to open RTF file through my VB application and print it?
Kindly help me

I am trying to find out what compatability level is set in sql. I have
an ado connection and I'm trying to run sp_dbcmptlevel. From what I
understand, you can run this sp with a compatability level and it will
set it. Or you can run the sp with a db name only and no compatability

We have a VB6 application using ADO to connect to  SQL server 2005.  The
application amkes several connections to several databases through the
execution.  We keep getting the error: "[DBNETLIB][ConnectionOpen
(PreLoginHandshake()).]General network error. Check your network

I am using ADO (AdoMain) as data conection in my project. When runnin
in VB6, it binds properly to the TextBox. But problem is when I want t
make exe file from my project. when running project.exe, the textBoxe
that I have set their DataSource Property to AdoMain by using code

I am new to VB and SQL. I am working on a form on VB.Net.
I want to populate the cbobox with data retrieve from a database from sql
server.
here is the code, but it generates error. I have no idea what's wrong. Can

I'am a newbie to vb6. I have been working on a database for some years now.
I have created a query in access and the report calls it. The criteria is
[Enter the Work Order ID] this information is on my form in vb. So is there
a way to send this criteria to access from within vb ...

This is really a performance issue...I think I've maybe gone about solving
this the wrong way.
I have a database table with only about 500,000 rows in it.  This
information is populated over time

hallo to all,
how can I open a passwordsaved database? If I open it from desctop, the
database ask the password, I type it in and the database is open.
If  I want to open the database from the application the answer is (in

Hi all, I'd like to save myself a couple of months of hard work and see if
its possible to use a report format created in Access (via a SQL in Access)
in my VB6 program.
I use Access to create the query in the first place, and importing that is

I am working with vb.net 2002 and SQL MSDE 2000.
I have some records in my SQL table for testing purposes and I
initially set up my vb form with my text controls bound to my data
adapter (da1) through the properties of the controls.

I need to lock a record while a user edits that record, so other users see a
"Record is locked" message when try to access that specific record. I know
there is a lockrecord property in Access, but I'm not sure how to lock this
record from my vb.net form.

Could someone please help with an SQL question.  First Let me explain
what I'm trying to accomplish.  I have a small Address book application
that has a search feature.  Currently you have to type the Firstname
and LastName exactly as it was entered in the Access Database record

I am writing some programs in VB6 and attaching to Access 2003.  Which access
method is better ADO or DAO?
Thanks

I am building a conversion module to convert DBASE IV database to MS
SQL SERVER 2000
database.  Using the DBASE IV (.dbf) files, I am able to create similar
table in SQL but I am unable to insert the data from DBF to SQL. The