VB Forum / Database Access / August 2005

Using VB6-Pro/SP4 on XP-Pro/SP2. I'm having a problem with getting code to
recognize that a table defined using the Data Environment Designer actually
exists (and it really does exist, with just one record). I named the data
environement simply as "DataEnvironment" and it ...

I have an Access 2002 database with 50,000 records that
I read in a VB6 program using the Jet version 4 engine
and the ADO library.
I have noticed that using Select to filter queries

Hi I've inherited a program that uses bound controls.
I've hit the same problem that most people must hit - binding a
datefield to a text box  - clearing contents and then saving - data
conversion error - cos I'm writting "" to a date field.

I am kindly asking for a help.
Software I use:
Windows 2000 Version 5.0 (Build 2195: Service Pack 4)
MS Access 97 SR-1

I seem to be realizing that I am having the same problem for my 5 years old
program now.
The JET-ODBC driver just keep popping up all kind of errors:
attribute cannot be set now

 I encountered a problem when was trying to export data from Excel to
Access through DAO3.6 because DAO3.6 is fit for access up to 97.so plz help
me to export data from Excel to Access2000 by using ADO !
THX

Currently developing on a workstation with an outdated ADO reference
and I need to bring the ADO ref current to work with the latest MDAC
2.8 installation.  This development will be accessing Sybase Adaptive
Server 8 ....

I am using ADO 2.6 against an Access database and can't get the SQL CASE
statement to work :
SELECT year, sum(CASE Product WHEN 'OIL' THEN Amount ELSE 0 END ) AS Oil
from Production GROUP BY Year

   I posted this in the vb.syntax newsgroup also. I wasn't sure if this was
a vb syntax question or an AD question.
   I'm using VB6 and Access 2000. I'm running an ALTER TABLE SQL statement
to change a primary key on a column and datatypes on other columns. I'm

   I'm using VB6 and Access 2002. How can I use a SQL Statement to delete a
constraint?
Thanks in advance
J

I would like to connect an Access database via my VB code.
There is an example somewhere I can use ??
Thanks
Yves

I am developing a project using Oracle9i. I have a problem about opened
cursors. I am using "ref cursor" to get the data from my application. But
after i have requested the data, the cursor remains opened. I cannot close
it. So a few minutes later, error message is saying that ...

Do I understand correctly that I need to use a different format for my
queries when they include a date field depending un the underlaying database
server?
SELECT * FROM EMP WHERE StartDate>#1/1/2003#   works fine with the Jet

I am trying to import a spreadsheet into MS SQL 2000 via a DTS packaget
using Microsoft JET database engine, but it gives me an error saying
" Workgroup information file is missing or opened exclusively by another
user"

I connected to a .mdb database with the IDE in a vb.net application.
When I distribute my application the program search the database on the
path specified in datasource (with the IDe and not with code). Is it
possible to map the datasource to application path (using the IDE