VB Forum / Database Access / January 2005

I am accessing a database as follows:
DATABASE_NAME = "c:\s4.mdb"
Dim S4 As Database, Groups As Recordset
Set S4= Workspaces(0).OpenDatabase(DATABASE_NAME)

Hello Group!
I need a bit of help about SQL query. I'm noting down a sample below:
Customer table
-Customer ID

I have an application where I update the database daily.  I'd like to
email out just the day's results.  The actual data is generally one to
ten different records on a given day.  I want the data as pure text to
show up within the body of the email.

  My software application uses some DAO fields with the type dbDate.
However many of my international users have been getting the following error:
3077 Syntax error in date in expression. Is there any way I can fix this?
  An example script:

Because I am not and do not proclaim to be a DBA, I need a bit of help.
Here is the scenario:
I am working on a VB program that stores entries into a dog show.  Each
entrant is assigned an armband number and each entry is one dog, however

I have developed a web page that uses ADO on the back end, and something
strange seems to be happening that I can't quite put my finger on.  When the
user clicks on a link in the main window, a popup window appears displaying
information from an ado recordset (which was created ...

I'm using VB6 for the front-end of an Access database.
I've connected my fields to the database.  
Now here's the problem... When a date is deleted the program crashes.  It
gives me a Data type conversion error.

I have an Access table with ~20,000+ records.  At a certain point in time, we
update all the records in one SQL query so that the current amounts are ready
for dataentry.  Currently I'm using adoCnn.Execute to perform the update
query.  However, when it is run over a Novell ...

i have a VB6 project which works with a Jet-database. This project
references the ADO 2.5 typelib for backwards compatibility. Generally the
deployed application works fine under every Windows-Operating-System with the
newest Version of MDAC.

 My software application uses some DAO fields with the type dbDate.
However many of my international users have been getting the following error:
3077 Syntax error in date in expression. Is there any way I can fix this?
 An example script:

I've written a desktop application in vb.net that connects to an
Access database using a connection string.  The db is on a remote
server.  When I install the application on a windows XP box,
everything is fine.  If I install it on a windows 2000 box, it will

Hello i am new to this site and also VBA.
I have a problem that I could do with some help on if possible I would
be very greatfull.  
I am running windows 2000 and office 2000.

Dear developer,
I have a problem when create an add edit delete application. After add or
edit or delete a record, why I can not see the updated result, just after do
it. I have use the Update and Requery property each time I addNew, Update or

Hy,
I display table recording of my database. aid of data adaptater and dataset.
I modify them in datagrid. then i update the datagrid and dataadaptator and
when i check the database the modifications are not taken into account.

When i am trying to connect to my SQL server using the
SQLdataadapter or the OLEDBdataadapter, VB tells me that
i can not connect to it. I can not even make a new
connection. Any Ideas