VB Forum / Database Access / August 2005

I'm having a problem accessing the MSYSOBJECTS system table from VB6. When I
do, it errors out, telling me that I don't have READ permission to read data
from the table.
My connection string is:

I have a mdb called treesy.mdb.There is a table,named transcipt with three
fields:serial_no, eng,sound
serial_no:1-10
(10 numbers)

Hello there..
the basic question is this - are there known issues with a sqldataadapter
update method not processing all of the deletes and / or updates listed in
the modified table?

I need to change FieldSize Property of the Field in the database.
Table is already created and it contains data.
I must do that from my app.
Can someone help?

I have a datagrid on a form and then another form where I update single
records.  The data gets updated from the form .
But when I return to the datagrid - I have to hit the refresh button to get
the new data to show.

In the new version of MS Access, I would like to know which version of DAO
that will be packadged with Access?
thanks

Cleaning up some old code in a VB6 app that has a JET database backend
(which I haven't used in a couple of years), so I'm trying to streamline
some of the queries and ran into a snafu on this one.
I can successfully run this query on SQL 2k, but not against a JET database.

I'm implementing an optimistic concurrency model within a VB.net
application.  I'm able to trap concurrency errors caused by an Update
command, and can easily work with the DataRows which have errors, but cannot
figure out why the ColumnError properties are not set.  Using the

In my application there is a situation where i have to use two database
simultaneously. I have to establish the connnectionn with those two
databases. Is it advisable to use two database connection. But its necessary
for me. How to use two connection string in the Web.config file ...

Using SQL Navigator Release 4.4.1.501, I went to the SQL Editor and ran
a query and like usual, the data came up in a window that was split,
1/2 was the SQL and the other was the result set.
I resized the result set to see more of the data, but I sized it too

I'm using the variable sqlstr to store the query, but I got this error
--- syntax error(missing operator) in query expression
The query works fine in Access:
SELECT nomeprojecto

I have try to set col(4) date form from mm/dd/yyyy to dd-mm-yyyy or
dd-mmm-yyyy(1-jan-2005)
but also fail.Pls help me to change it.

I'm trying to execute a stored procedure which expects 2 parameters.
When my code hits the execute line I get the runtime error "Procedure
'UpdateNormPlan' expects parameter '@VersionNo', which was not
supplied"

I want to give the user control when unloading a form. User shall be able to
decide wther to save/not save data in the database. the Validate - sub should
be triggered automaticly when the form unloads, and I can place this code in
the sub:

I have a datagrid on a form and then another form where I update single
records.  The data gets updated from the form .
But when I return to the datagrid - I have to hit the refresh button to get
the new data to show.