VB Forum / Database Access / January 2004

I was informed by many-a-person that the Access autonumber is only
going to work if you're adding records from within the Access
environment.
However, a test program I just made has disproved this. Using the ADO

I am using VB6 sp5, I have a table and I want to append stars to some
values, It never work s
x = * or ** or *** etc ..
sql = " Update table1 set field1 = field1 &  '("  &   x  & ")'"

My company has four web servers running copies of same ASP web application. One of the servers is running on windows 2000 Advanced server edition (without service pack) , MDAC 2.6. The other three servers had windows NT OS and MDAC Version 2.5 installed. We use microsoft SQL ...

Hi ng,
i´ve noticed that there´s a similar thread, but i post this anyway coz
the other thread didn´t solve my problem.
I try to execute a SP on SQL Server 2000. My code:

I am working on a program that will go through and relink tables in various
databases.  The only problem that i have not solved is how to create a
multi-field primary key on my linked table.
Example.  I need to create a linked table  STACEY

Could anyone help me with this Please, below is the code I've been trying
but it's not working. A user selects a start date and an end date. Table has
a BeginField and EndField. If  dates selected by the user exist in the
database, the prompt user(Dates not available).

I want to fetch the location of Winword.exe from the registry.
What's wrong with the code below?
Greetings,
Lex

I have probram with dataenvirnmemt
In one of the forms i've changed the data of the table relate to the data
envirnment. The change was with ADO
But the data on the dataenvirnment didn't updated while the database

I don't know if it is compatible, but does anyone know the ADO provider for
JDatastore?
Thanks,
Randy Whitehead

I've written a VB6 application that uses a MS Access DB
with ADO. I get "application defined or object defined
error" message when datareport is invoked. It works fine
in machine having vb6 installed. Can anybody tel me which

Hi all..
I have a somewhat simple question, which I simply cannot figure out what
went wrong.
I need to extract a date in grids to date format.. and then store it in a

I need to open an adodb recordset for exporting to an excel object using excel's copyfromrecordset method. I am having a problem because I need to be able to get a record count. for some reason I can only get a recordcount on small result sets i.e. a query returning ~15 rows If ...

I have a datagrid that is populated from an ADO using an
access table. (VS6 & Access97)...(yes i know i must update
access!!!)
If i run a querydef that updates a particular field in the

Could anyone please help me with any method to search a database. I am trying
to search for range of dates. Example: I want to find if
1/02/2004-1/15/2004 exit in a database. The table has two fields;
StartDate and EndDate.

I have a query that runs in 3 second when executed through
SQL Query Analyzer. When the same query runs in an ActiveX
object using ADO 2.0 connecting to a SQL 2000 server, I
get the error [Microsoft][ODBC SQL Server Driver]Timeout