VB Forum / Database Access / January 2004

       I have a table with only one record that I use to store some
settings.  What is the easiest way in VB to set the value of one of the
fields.  For some reason, the line of code that is there is:
 tbl.fld = newvalue

does someone know why the SQL command ROUND is unknown on my Windows XP Home
system
using ADO 2.7 ?
Executing the SQL command in Access everything works fine. On my Win2k PC

Is there a way to call a VB program from a SQL stored procedure?  Thanks.
Michael

I am new to ADO, sorry for the lame question.
How do I open a recordset in a current Access database? In DAO I used:
Set db=CurrentDb()
How can I do the same thing with ADO?

I tried to use this code to connect to an existing Excel file from Access
database:
  Dim TargetFile as Object
 Set TargetFile=GetObject("MyFile.xls")

Can anyone help
I am trying to perform a select query from within VB connecting to a SQL
Server 2000 database.
I am trying to select and in the where clause i want to search for a date.

The program I wrote is supposed to keep track of X recent phone calls.
Every morning the program communicates with a device and collects the calls
log of last night.
Is there a quick way to keep only the last X and delete all the previous

I'm having problems updating a boolean value in an Access database.  The
value is defined as a Yes/No type that I've always assumed could be treated
as a simple boolean.  To update the value, I retrieve the data from the
specified table into a DataTable from a OleDbDataAdapter.  I ...

I wrote an application in VB6 SP5 that connects to an Access 97 database.  I am using ADO 2.7 SP1.  The program has been running fine for over a year.  It was installed on a Windows XP computer and now the application cannot connect to the database anymore.
I read that this means ...

I am getting the Time out expired error in VB in the following scenario
1.  Table named "EntityMaster" which has around 15 fields and around 150.000
records.
DELETE FROM EntityMaster WHERE DataSource = 'R'

I read in MSDN (here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/mda
c25.asp) that WinXP installs MDAC 2.7, and have also read that as of v2.5 of MDAC the Jet DAO dlls are not included.  So how are Jet 4/DAO 3.60-based solutions supposed to be ...

We are currently writing to an Access database using DAO.  What we need to know is if there is any way to set the timeout time to write to the database through code in milliseconds.  for instance, right now the timeout is set at 1 second.  We need to set the timeout at 100 ...

Is it possible to use the keypress to autoinser/autotype a character
into a string following a specified format(eg 22-4444-7777)? example--
After entering two characters (12) into a txtBox which is a datafield
for my ado database eg

Are there any distinct advantages to running a vb application with Access
2000 tables rather than Access 97 format?  Performance, integrity issues,
etc?
I currently have a application with Access 97 format and am considering

Can you think of any reason why a recordset gained fro
set rs = cndb.execute("sp_mysp1"
might not work. It doesn't raise an error, but after the call to execute, gains a state of zero, and not 1 - and hence all subsequent operations seem to generate 'operation not allowed when the ...