VB Forum / Database Access / March 2005

When I have an empty recordset and I do
rs.AddNew
'add each item to recordset...
rs.Update

I need some urgent help on cleaning the temp tables in my DBASE
Database. The application gives me a database engine error stating
Insufficient Disk Space; And the cause has been traced to temp files
size increase. So I need to figure out where the temp files in DBase

I am creating a new table in ACCESS, writing from a recordset of 42
rows.  When I close the table, and bind to MSFlexGrid,   I see either
the 2nd, 7th, or 8th written row as first in the grid.  Count of
written rows is 42, but upon opening the ACCESS table, I see the first,

I'm developed VB application and using ado object for access and change data
in Access database.
and if I run code like this
set cn=new adodb.connection

We are trying to convert a VB6 program that uses Access 97 databases to use
Access 2003 databases (finally).  The latest issue I have run into is trying
to set the LockEdits property to False.  Worked fine before but now does not.
Is this property gone??  values changed???  Any ...

I've to print some items from a listview and i would like to use datareport.
These items are not saved in a database so I can't give a data sourse to my
data report...
Is it possible to use data report to print these items????

In vb6 the following code works fine:
I pasted the sql from Access into a test form.
***********************************
strName = "Johnson"

I am using VB6 and DAO with an Access 97 database.  I am trying to save
numerical data from a textbox. The Access field has been set up as Data Type:
Number,  Field Size: Long Integer,  Format: Standard,  Decimal Places: 0.
Everything is OK if there is a number in the textbox, but ...

I have the following code :
strSQL = "SELECT * FROM PropertyImage PI Inner Join Property P ON"
strSQL = strSQL & " PI.PropertyReference=P.PropertyReference "
strSQL = strSQL & " WHERE P.PropertyStatus IN ("

For some reason i keep getting "strange" characters from a sql-query.
To simplify the procedure;i've created a table tblTest into a mySQL
database, inserted the value "Azië" and queried that table.
The returned result looks fine. But when i do the same thing with

I have the following in my SQL statement
DatePart('yyyy', DateAdd('m', 4, NOW()))
which works fine and gives me the current year of 2005 adjusted so it starts
at begining of sept.

I can´t seem to figure out the correct syntax for the "INSERT INTO"
statement
using VB6, Jet 4.0, and an external database that is password protected.
Here cntex is a connection object, that is connected to the database that

I'm to access a Dbase on a net. I'm doing it in two ways, with ODBC and
directly by Microsoft Jet.
When I use the ODBC the connection is extremely slow, but I can read it
always, even though another program are using the dbase files.

As soon as I fill in a decimal 45,67 ....prog says : error in the update.
I tried everything, but nothing has helped so far. So when "prix" is a
decimal number, there we go.
Sub sla_op(ByVal soorten As String, ByVal datum As String, ByVal prix As

I am trying to quickly learn ADO.NET, and building windows
applications. I don't learn well by taking those 3 day classes, and
books are only good for references only after I have some basic
experience.