VB Forum / Database Access / January 2004

My app is aVB5 front end for an Access 97 database.  It currently runs on
about 15 NT4, 2000, and XP workstations.
From time to time my IT department relocates the database on a different
server. This might then result in several database corruption incidents each

To do queries based on date parameters with jet does the date have to be in
mm/dd/yy format or can it deal with uk date format of dd/mm/yy. If not
presumably the date format will have to be changed each time data is stored
and dsiplayed?  If so What is the easiest way of doing ...

I need to check from within VB.NET code if the SQL Server
database is started. Can I do this? If so, how?
If not, is there a way to start it programatically?
Thank you,

I'm not new to VB, I have been programming it for a while, but I am new to
VB.net.
I am using a ADO object to use for my database and the database is Access
2000.  I have the connection set right.  I can tell that because when I

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

Sorry friends, I'm a new VB user.
I would like to save some VB data in an Acces db (not using a gridcontrol).
How can i save data.
Leo

Hi, how can I get the field "Status" from the Exchange table returned in the
following query?
SELECT * FROM Orders O WHERE (ContractCode IN (SELECT C.ContractCode FROM
Contract AS C WHERE C.ProductCode IN (SELECT ProductCode FROM Product AS P

I am currently passing record information back to my ASP clients via a
delimeted string ("fieldname1=value1;fieldname2=value2...").  This has been
a neat appoach for me so far, as it avoids all the hassle of stateless
component function taking 20 parameters, or having to code 20 ...

Hello hope you have a great year
i am novice in database and have some dificulty to understend ADO.
Database is Access 2000
Table Fields is |Name|2004-1-1|2004-1-2|.....|2004-12-31|

This problem is staring me in the face but I cant seem to find it. I have
two text boxes one of which is bound to a database
I want to run an sql statement to update. Here is the statement
clsQuiz.RunQuery "Update Identification Set StudentPass=' txtNewstpass'

I have an application that connects to an Access database and the
records are shown in a datagrid. In the app, the end user will need to
be able to delete certain records. There can be several records that
will need to be deleted each time. Using the code below, the app

I have a text file with around 10 names I would like to
use the names to gather other info from other source.  My
only request it how to access this text file and read the
content in vb.

i have query result that i want to export to excel new
file.
1) how can i do it?
2) is it matter how i hold my query result (recordset,

I'm using an Access DB connecting through ODBC with ADO3.6 with VB6.0.
I open the connection once the app is running and only close the connection
once the
user closes the app. If the user updates many times, info and images(as OLE