help with microsoft ADO control/True DB Grid
- From: Drew <drew@xxxxxxxx>
- Date: Fri, 09 Sep 2005 08:29:21 -0400
Hi All:
I have a simple VB6 project that allows a user to simply read and
update data from a table that is in an Access 2003 database.
The form of my project has the ADO data control and a True DBGrid OLE
8.0 Control on it.
I've set the ADODC connection string to Driver={Microsoft Access
Driver (*.mdb)};Dbq=p:\drew\stormlog\storm2.mdb;Uid=Admin;Pwd=;
and I've set the recordsource to select * from stormlog
The grid has ADODC1 selected as its data source. The grid is loaded
fine and data is displayed and can be browsed thru.
In some cases, I can change data in a column and move off of the
record and its updated as one would expect.
The problem is that about 1 out of every 5 records can't be updated
via the grid. On those records, when I move off of the record after
changing a field's value, I get this error:
Row cannot be located for updating. Some values may have been changed
since it was last read.
The only value that has changed is the one I changed in the grid.
Although the database is on a network drive that I can read/write to,
no other network users have the database open, so its not a record
lock issue.
Again, most records can be updated but seems like about every fifth
one generates this error message.
I don't have any AutoNumber fields in the table. Its a pretty simple
table with 5 fields.
Any help is appreciated as I'm stumped!
Thanks
Drew
.
- Follow-Ups:
- Re: help with microsoft ADO control/True DB Grid
- From: Steve Byrne
- Re: help with microsoft ADO control/True DB Grid
- Prev by Date: How 2 use DB relationships without re-programming them in VB.NET?
- Next by Date: Re: ADO Find Help?
- Previous by thread: How 2 use DB relationships without re-programming them in VB.NET?
- Next by thread: Re: help with microsoft ADO control/True DB Grid
- Index(es):
Relevant Pages
|
|
