VB Forum / Database Access / June 2005

   How do I use the SQL alter table statement to:
       create a one-to-many relationship,
       enforce referential integrity,
       cascade update related fields, AND

Did not get much help in the microsoft.public.vc.database,
so I will try this question here...
I can not get this to connect.  I'm trying to make a DSN-Less Excel
connection.

   I'm using VB6 and Access 2000. I need to create a text file that I could
open and execute from my app at run-time. Could someone point me in the
right direction?
Thanks

I've built a VB app with a Access Database back end - works perfectly on my
system but after installing on a friends when trying to connect to database
he get's a message saying "Run time error 429" which I think is something
about 'Cant find database', I've also installed the ...

I have a table in Access something like this
ID Date        Time
1  01/01/05  0900
1  01/01/05  1000

I have a simple SQL Insert statement that is causing the error:
-2147217900: Syntax error or access violation
If I run the statement in Query Analyzer it runs fine. Here is the
statement:

Okay guys here is the situation.
When I attempt to run the following update query in my VB app I get a
timeout error.  The query takes about 30 seconds to run in query analyzer
the first time (after the first successful run the next attempts take less

I have a simple little application that I am writing that will allow the user
to view a bitmap fle, and then save that to a foxpro 8 database (General
field in a table)
What I need to do is pass the name of the graphic file to the database as an

I have an Access datbase with 5 reports.
When I open the Access application in VB and look at .reports, the
count is 0.
I can look at .currentproject.allreports and the reports are listed.

Current database has separate table structure (identical) for each Class of
Vessels. I need to bring everything into a centralized set of tables, rather
than having 5 tables for each class. (Poor design but I'm trying to fix it!)
The current primary keys are autonumbered per ...

Okay guys here is the situation.
When I attempt to run the following update query in my VB app I get a
timeout error.  The query takes about 30 seconds to run in query analyzer
the first time (after the first successful run the next attempts take less

hello i have a form in visual basic.net
i load this window/form when starting the application.
in this window i have fields which are filled with data from a
database.

I am using VB.net 2003 to update MS Access 2003 database with the following
code.  The codes executes without any errors but database won't update, what
am I doing worng?
Dim sSQL As String

Currently I have a Win 2k (WWW) server on the outside of my network and
have a hole poked through the ISA server to allow SQL access.
The ASP script below works fine.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

How can I search a Date/Time field based on the Date part, for example to
find all records for 6/7/2005. If I do a WHERE DateField = #6/7/2005# nothing
is returned because of the time values stored in the fields. I need to keep
the time values in the fields for sorting.