VB Forum / Database Access / February 2006

I have an access database with 2 tables. One table contains names. The other contain 3 fields that are linked by name. I'm using ADO in VB. What I want to be able to do is add information to the 3 fields that are linked to the name. So if name = "Dave" then addnewrecord to the ...

Does anyone have a function that returns the day of week (Sun-Sat) from a
user supplied date (4/12/2006).
Thanks!
Ron

I have an access database with 2 tables. One table contains names. The other contain 3 fields that are linked by name. I'm using ADO in VB. What I want to be able to do is add information to the 3 fields that are linked to the name. So if name = "Dave" then addnewrecord to the 3 ...

I have a table that has a list of products. I would like to display those
products on a form. There would be 4 columns.
ItemID Description Price QTY
The first three would be pulled from my products table the last one would be

What is the proper syntax for this command in Visual  Web Developer Express
UpdateCommand= "Update Table set A= '" & <% Session("XX") %>  &"', B=@b".
I am trying to pass the data stored in the Session("XX" ) to the SQL and I
am getting an Error on that systax.

I'm using VB3 and Access2003 and DAO.  I am trying to import a table from one
mdb into another mdb.  I can successfully open the source database as
readonly and the destination database as readwrite.
I am trying to use  the statements

I am trying to create a GUIID unique number but cant find the create
GUID button anywhere, I am using VB.net 2005 pro and am sure I had it
in my other job.???

im trying to connect to a microsoft access database from an ASP.NET web
form.
i keep getting the following error though:
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Could not use

I have a process that creates a recordset and saves it using :
rsData.Save oStream, adPersistXML
to a field in SQL Server. 99.9999% of the time the file that was saved to
the database is able to be loaded into a recordset using:

my question is, How can I find the field sizes from a
DBASE IV database. I am using VB6. I can successfully
retrieve the column names but I dont know how to retrieve the
field types and sizes.

if my data table is using 3 or 4 fields as primary key,
can i check is it the uniqe when the user updating information in datagrid?
thanks so much

Help!  I've created an OLEDB DataAdapter by drag & drop onto my form and
automatically generated the update SQL statements, opened the connection,
filled a dataset closed the connection, amended the first item of the first
row, accepted the changes to the dataset, confirmed the ...

Hi gurus
I have a VB6 app in which I need to read data from an Excel
Spreadsheet.worksheet row by row.
I was going to import the entire Spreadsheet.worksheet into an Access

Thanx in advance
Help required on setting up a connection to SQL database through VB6
application over Internet.Database is hosted on machine having static IP
address.Database has to be connected through public interent from VB6

We have a Outlook add-in programmed in VB6. It uses the Redemption
library to avoid Outlook security warnings. The instancing for the main
class module is 6-GlobalMultiUse.
We are experiencing an intermittent Error 91 condition in certain