VB Forum / Database Access / November 2004

Please enlighten me with the big picture of XML.
I have an organisation who wishes a vb/database
application I am in the stages of designing send the data
entered by participating organisations in an XML format

Does anybody know the best practices to support multi-users. In my case I
have a client application installed on several machines which access a sql
server database.
I tried the pessimistic locks. Then if somebody else tries when a data is

hello my self avi
i am developing application in vb by using ado
i used getrows method to get data in array.i got properly but i also want
to add data return from another query in same array by using getrows

Can someone show me the proper syntax for opening an Access db using a
DSN-less dataset that uses a system file?
Thanks,
Brad

Hope someone can help.
I am having problems formulating an SQL INSERT.
I have sqlRun = "INSERT INTO TableA SELECT * FROM INNER JOIN [TableB] ON
TableB.X = TableC.Y"

Hi, there!
1.I have a VB script. It works as I need.
[..skip..]
sSQLQuery = "Select Size From sysfiles Where Name='EEA_DATA'"

 I have large text in a multiline textbox. It was generated from the
database. Ex.
job   size   qty   lay   bdlno  opr      
job   size   qty   lay   bdlno  opr

Through VB I am editing one record from a sql server 2000 database. I want
to disallow other users from deleting the same record. When I use
adOpenKeyset, adLockPessimistic combination to lock the record. For the user
who is trying to delete the application hangs. How do I get an ...

I am starting to use connection strings a bit more now in coding and am
a little confused.  If anyone can clarify some of this for me, it'd be
great.  Here's what I'm doing:
If I have some code like this:

hi myself avi
i wana find ubound of multidimensional array in vb

I hope this is an appropriate group for this question...
Basically, I have created an oledbDataAdapter in vb.net and passed it the
query string:
"Select * from Employees where emp_id = '1' and (date_field between

Through VB I am editing one record from a sql server 2000 database. I want
to disallow other users from deleting the same record. When I use
adOpenKeyset, adLockPessimistic combination to lock the record. For the user
who is trying to delete the application hangs. How do I get an ...

In VB6 When I use the data environment I get an automation error It says
Automation error element not found.
I reloaded VB6 many times but the data environment still wont work Why?

VB6
Access2003
When i try to open database an error accures
unrecognized database type

I am trying to trap the error that raises when you attempt to query a
database that does not exist. noted that DAO.DBEngine.Error.Count does
contain the value of how many errors have happened. Just cant seem to
catch the error so that It can be handled correctly, heres what I am