VB Forum / Database Access / February 2004

I'm porting a DAO application to ADO. The application uses an Access
database (.mdb)
In the DAO application I create a number of queries which is then executed.
One of the queries does an INSERT into a table depending on the result of a

How can I query the Windows regional settings from VB6?  I need to identify the decimal separator (comma for French and period for English).

I'm having problems with the apostrophe when I save info
to the Database (SQL Server), I'm using ADO and VB 6.0
William (Bill) Vaughn posted a reply as follows:
--------------------------------------------------------

Could anyone help me with this Please. I want to write an SQL statement in
VB.
A user enters a start date using inputbox. Sql statement searches database
with two fields,

H
Can someone help me with a sql query in which I have to update a field in a table after checking if the flag for that particular record is set in another table
Mat

Please forgive if silly question but-
Is it possible to generate a spreadsheet style(excel like) report with
cells which are values from text boxes(bound to a access db)?
I would like my form and printable report to look identical to a

What should I do if I want MSSQL 2000 Server automatically store <null>
value into a DATETIME column instead of '1899.12.30', '1899.12.31' and  'AM
12:00:00'.
Thank you...Douglas

I have a program using VB6. It was working fine on Win98. Now I try to run the program on WinXP but failed.
The source code is list as below
   FileCopy "d:\test\acct.dat", "d:\test\temp.dat
   Set dbsText = OpenDatabase("d:\test", False, False, "TEXT;"

I have written a stand alone program (runs on my PC only).  It is a payroll
program I use to pay my employees.  I want to take it to the next level and
would like to put the Access db on my IIS webserver.  The only problem is, I
don't have a clue where to start.  Can you all either ...

Can someone please help me out with this?  I am using VBA within Access and
would like to use ADO if feasable, so as eventually, I can see about having
the data taken over to MS SQL Server, but have to build my DB program, get
it working, and I do have various requirements involved. ...

Is it possible to rename tables and fields by using ADO? And how to do it?

Ug.  Solve one problem, get another.
I'm trying to bring up a record of a database (made in Access XP), but I'm
getting the error "Run-time error '3800': 'Field1' is not an index in this
table

Im currently using DSN's to connet to SQL Servers ( Live
and Devolopment )
I read somewhere that you can connect without having a
DSN created,,  has anybody heard of this?

I need to know how can I read/write an image into BLOB Oracle 8i Field using
ADO and ASP.
Please, answer this question as soon as possible, I´m gettiing deperate !
Regards

For better or for worse I have been building VB6 apps using DAO and Access 2000 databases.  A client wants me to write a new application which will look at 2 Visual Fox Pro 8 tables.  The client provided me with the tables (.dbf, .fpt & .cdx) but I can't get them open
I tried ...