VB Forum / Database Access / February 2005

  I'm working with very long queries for insert, update and select, and
having a lot of troubles about updating data as some fields are very
large text ones. The problem is VB is cutting down my SQL-query string
so it doesn't work.

I have created this query in Sql Server 2000 and I need to run similar query
in Oracle.
update cont_item
set psqft=sqsm

Hi,
Got a small app based around a access database. In
ADO.net i simply called update method to uptade my
database with dataset contents. i.e.

Please help! ( Newbie)
I can't figure out how to make my little program accept negative numbers.
...should be "-2.5 " to "-6"
Thanks.

Any possible way to make VB5 open an access 2000 database?? Always getting
an 'unrecognized database error"  sooner or later. I have done the obvious
things, updated all visual service packs, update to jet4.0 and mdac3.6.
Checked for the references. I did open the VISDATA project ...

I am converting from VB 6.0 to VB.NET and I want to use FoxPro tables. Can
anyone show me a piece of VB.NET code that will allow me to open and access
FoxPro free tables.
Thanks,

Indeed, a count of a query with a group by function gives more records than
there are and so for-next  structures don't function.
How is this to be mended.
Anyone? Everyone in fact.

I have installed SQL 2000 Server on my standalone PC and want to store
tables in the database folder ( which originally came from MS Access). I want
to connect to these tables using a DSN-less connect from VB6. Previously with
ACCESS the connection string was simple:

I'm busy trawling through documentation trying to puzzle out an issue I'm
having. Am about to tackle the SDK.
OK, I'm using MDAC 2.8. Visual Basic 6 and SQL2000 SP3a.
If I execute the following code through a normal ODBC connection (In Admin

my self avi developing accounting application in VB6 and Access for
traders. i have 2 tables AccountTable And Accounthead Table Fields r
AccountTable - Accountcode      Double [AutoIncremented i.e max value of
in table]

I am using ADO(VB6) begintrans and committrans. Within these statements
I call to procedures. The both update different tables on a SQL server
7 database. What I am trying to do is if the second stored procedure
fails, I want to check for a specific error message. If it finds this

I have a problem with my MySQL (version 4.1.7):
The last "update" does not work, meaning that something with the
filestream is corrupt.
Any Ideas?

I have a question about using a database. Now i have a Microsoft Access
database with tables, queries, forms etc. I wonder if it's better to use
Microsoft Access (with forms) or create a VB application as user interface.
There is a need to make it multi-user.

I have added a access mdb file as a resource to my VB.Net windows app.
Is there a way of reading and or writing to it without first steaming
in out and saving it as  a file on the harddrive?

I would like some advice on (using VB .Net and MS SQL 2000) what the most
efficient and fast way would be to return ~10,000 records from 50 different
queries and then group by and sum these records back up into one 10,000
record source.