VB Forum / Database Access / October 2005

Hi Guys / Gals,
I have come across an interesting challenge today, and even after eating
several tuna to stimulate my brain activity, I have yet to come up with a
solution, so I thought I would pose it to the combined intellect of the

I'm writing a server application that will receive messages from multiple
clients via TCP ports and update a DAO database.
One method I can use is to process the messages one at a time (event-driven)
on a first-come-first-served basis, but it occurs to me that it would be

I'm trying to build an attribute string  to use in the RegisterDatabase
method to create a DSN for AS400.  Does anyone know?
Thanks.
Matthew Wells

I have a VB6 application that is getting intermittent 3260 errors.  The
database is on a Win2000 network server.  The database has a "job"
table that points to other databases.  In order to "lock" the job a
field is set to true in the record when the user wants to perform an

I have been searching for XP icons relating to databases.  Even a suggestion of one would be nice.
Searching Google, I found one or two and did not like them.  One was a CD with the letters DB on it.
I have been using the picture of a safe and am not 100% satisfied with it.  Any ...

Working with a MS Access 2002-format database, I'm firing off the following
query (VB format):
SQL = "SELECT UI FROM Issues I RIGHT JOIN Update_Issues UI ON (I.FullIssue =
UI.FullIssue) AND (I.Title = UI.Title)" & vbCrLf & _

Can someone show me some sample code to simple Open an Oracle database and
add a new record into a table if I have a DSN entry setup to the database?
I think I have it correct but am getting some odd errors that I would like
to compare against.

I am writing a VB application which imports a csv file into a access 2000
database file and then manipulates the data in the file
I am think that there exist an easier way of accessing this data from other
than using ADO  to read it from the file only to then write it back to the

Is there any option/method to protect a Ms Access(.mdb extension) file
from deleting/opening the file. Please help me.

I want to save a bmp to a Ole Field (mdb) from vb6.
I found a lot of solutions, but all of them save in the OLE Filed a Binary
Stream. With this informations Crystal Reports can't show a picture. The
Field show Binary. If I give a Bitmap with Access to the Field it show BMP

I am creating my database through code in VB6 for an Access 2000 database  I
have several fields that need a Date/Time field's Format property set to
"General Date" in order to store the time as well as the date.  Is this
possible through ADO?

I am trying to use the RecordSet.Save to save the records to a XML file.  It
works but all the fields are saved as the Attribute of the Tag instead of
the Element.  Is there any other way to make it save the fields as element?
or does it matter at all knowing that we will all die ...

I have extensive experience with VBA and some with VB6 (not much though) and
am working with the VB2005 Beta 2 IDE. I am attempting to connect to an
Access 2003 DB. I have the database setup with an odbc definition, now I am
attempting to figure out how to connect to the db. It ...

I would like to view a report by clicking in het menu of my VB-application.
I made a menu-item, but i don't know the code to open the report.
Now i have this, but it doesn't work:
Dim objAccess As Object, strWhere As String

After I delete a Recordset and then Add or Insert a new record, then the New
recordset will add to the positon of the deleted recordset.
Can I add the newrecord to the last cursor position everytime ?
I have tried use Movelast move the cursor to the last position then Addnew